Documentation

Outlook Mail Merge Attachment supplies mail merge process in Microsoft Office Word and Outlook with the functionality to add an attachment.

The script works as follows. First, you set Microsoft Outlook to work offline, this way the emails are stored in the Outbox but not actually send. Then you perform the mail merge using Microsoft Word as you are used to. All merged emails are now stored in the Outlook Outbox. Then you run the script, 'outlook mail merge attachment.vbs', which adds an attachment to all emails in the Outbox. To send you emails, you simply set Outlook to work Online again.

Preparation

How-to

  1. Set Outlook to work Offline.
    • Start Outlook, select ribbon [Send/Receive] » [Work Offline]. ([File] » [Work Offline] in Word 2003.)
    • This ensures that the email you send is stored in the Outbox before sending. You can try this easily yourself. Note: Make sure you do not accidently send the emails when you close Outlook.
  2. Mail Merge
    • Use Microsoft Word to mail merge your emails, just as you are to. They are now stored in the Outlook Outbox.
  3. Add the attachment to all emails in the Outlook Outbox
    • Run (double-click) Outlook Mail Merge Attachment.vbs
    • You are asked which file to add to the emails. Note that you cannot touch the keyboard or mouse while processing the emails.
    • Sometimes, the "Attach file" dialog is hidden behind another window. Please minimize all windows when OMMA seems to stop right after the welcome message.
    • When the script is finished, it will display "Successfully added the attachment to 12 emails".
  4. Check
    • You are able to check your emails with attachment since they still are in the Outlook Outbox.
  5. Send the emails
    • In Outlook, unselect ribbon [Send/Receive] » [Work Offline]. ([File] » [Work Offline] in Word 2003.)
    • Now the emails in the Outbox are really send.