email to members of distribution list with INDIVIDUAL file attachm

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thomas - 16 May 2007 00:58 GMT

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!!

Reply to this Message

Sue Mosher [MVP-Outlook] - 25 May 2007 19:20 GMT

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

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Hi community:
>
[quoted text clipped - 8 lines]
>
> Thanks a million!!

Reply to this Message