Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2007
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MailMerge to email (2003)

    I am using Word's MailMerge feature to email approximately 100 individual recipients. The email addresses are drawn from a separate Excel spreadsheet. I need to attach a separate document to this email as part of the MailMerge email process. Is this possible? Thanks in advance for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MailMerge to email (2003)

    Word's mail merge to e-mail feature doesn't support adding another document as attachment.
    You could write VBA code to create the e-mails, fetch the addressees from the Excel sheet and attach the other document. This would involve automating two Office apps from a third one, and require a good working knowledge of Word, Excel and Outlook VBA. See Merging With Attachments for an example, and note the warning about the security prompts you'll get and how to suppress them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •