Automate Mail Merge using SAS Enterprise 7.1

[siddhantk989]

Hi,

  I am getting data from database in SAS Enterprise 7.1 and my next step is to automate the mail merge process using SAS.

  Is it possible using SAS that I can merge the data with a Microsoft word template, generate letters and send those letters as an attachment to the designated customers?

  Any kind of help would be great.

  Thanks in advance!

Thanks,

Siddhant

[Kurt_Bremser]

Automation of Microsoft Office is best done with VBA. The csv for the variable fields in the Word-template can be created by SAS.

[siddhantk989]

Hi @Kurt_Bremser

 Thanks for the quick response and I completely get that writing the VBA code is more efficient as this was my suggestion as well, but the requirements are that I need to use SAS to do the process. Is there any way that this can done using SAS?

Thanks,

Siddhant

[Kurt_Bremser]

For Word templates, you need Word. The crucial activity has to happen in MS Office.

[Vince_SAS]

If you need to do this entirely using SAS, then see my post from yesterday.

Vince DelGobbo

SAS R&D

[Vince_SAS]

There are ways to send bulk email using ODS and the EMAIL engine of the FILENAME statement.  Here are some references:

https://www.lexjansen.com/search/searchresults.php?q=email

Vince DelGobbo

SAS R&D