Outlook mail merge attachment (OMMA)
Version 1.1.9 BETA, 26 October 2013
Information
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
- Requirements
- Microsoft Word and Outlook, versions 2003, 2007, 2010 or 2013.
- Outlook must be configured such that no messages pop-up when one presses the "Send" button. One known problem is for example the spell check that pops up before sending an email.
- Microsoft Windows
- In Outlook 2003, the internal outlook editor must be used (this is default), not the word editor.
- Knowledge
- The user is familiar with a Mail Merge using Microsoft Word.
- For Mail Merge in Microsoft Word 2007, see: "Use mail merge to send personalized e-mail messages to your e-mail address list". see reference..
- For Mail Merge in Mircrosoft Word 2003, see: "Answer Box: Send e-mail messages to a group using mail merge in Word". see reference..
- Download
How-to
- 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.
- Mail Merge
- Use Microsoft Word to mail merge your emails, just as you are to. They are now stored in the Outlook Outbox.
- 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".
- Check
- You are able to check your emails with attachment since they still are in the Outlook Outbox.
- 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.
About
Development
- Wouter Westerveld, Lead Developer
Contact and donations
Please consult the OMMA website for the contact form. Donations can be made using pay-pal, information can be found at the sourceforge website.
Disclaimer
Copyright © 2006-2013 Wouter Westerveld
This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.
http://omma.sourceforge.net