email to members of distribution list with INDIVIDUAL file attachm

[Guest]

Hi community:

Every month we have to send an email to 40 recipients (restaurants). The
email body is the same, but the attached file (or files) is different (each
recipient gets individual file). The files to be attached all sit in one
folder.

Is there any way using Outlook VBA to tackle that problem?

P.S. I'm a VBA novice

Thanks a million!!

 

[Sue Mosher [MVP-Outlook]]

It's certainly possible to write VBA code to generate messages and attach files to them. However, unless you have a burning desire to write VBA code, you might be better served by investing a few bucks in one of the mass mail tools listed at http://www.slipstick.com/addins/massmail.asp

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers