topic Automate Mail Merge using SAS Enterprise 7.1 in SAS Enterprise Guide

Automate Mail Merge using SAS Enterprise 7.1

siddhantk989 — Mon, 13 Aug 2018 17:28:15 GMT

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

Re: Automate Mail Merge using SAS Enterprise 7.1

Kurt_Bremser — Mon, 13 Aug 2018 20:19:17 GMT

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

Re: Automate Mail Merge using SAS Enterprise 7.1

Vince_SAS — Tue, 14 Aug 2018 01:18:32 GMT

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

Re: Automate Mail Merge using SAS Enterprise 7.1

siddhantk989 — Tue, 14 Aug 2018 15:45:02 GMT

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

Re: Automate Mail Merge using SAS Enterprise 7.1

Kurt_Bremser — Tue, 14 Aug 2018 16:12:24 GMT

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

Re: Automate Mail Merge using SAS Enterprise 7.1

Vince_SAS — Tue, 14 Aug 2018 16:18:27 GMT

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

Vince DelGobbo

SAS R&D