A Visual Basic script that does two impossible things.
- Add attachments to a mail merge.
- Change the sender on a mail merge batch, sender must have delegate rights. This is helpful to send from a Generic Mailbox, which your computer support department told you was impossible. It's not and you can do it now!
Mail merge is a useful tool, but it neglects several features that are often necessary when sneding a mail merge. Those features are the ability to add attachments, as well as to allow delegates to send the FROM option.
- Put Outlook in OFFLINE mode. Send/Receive Tab "Press Offline Mode".
- Run through your mail merge completely, all messages should stick in the Outbox.
- Run the .VBS Script.
- Add Attachments.
- Change the Sender if desired.
- Check that the items in the Outboox look like what you want to send.
Outlook 2013 and onward (probably backwards compatible all the way until 2003).
In Outlook 2013, it has been noted that some security settings may prevent the script from running correctly. To fix this try the following: launch Outlook as admin see here: (http://www.msoutlook.info/question/353) Shift right-click should allow you to run as admin. Then you can go to File > Options> Trust Center > Trust Center Settings > Programmatic Access > Never Warm me about suspicious activity. That same dialog will tell you if anti-virus is valid, and if it is we’re fine there.
Make sure Windows firewall is turned ON.
- Wooter Westerveld, Lead Developer OMMA
- Hexadecimalz
This code needs cleanup. I've attempted to clean-up most of the big issues such as spelling and grammar, but the code itself is not pretty.
It would be nice of some of the user-intervention, such as putting the program in Offline mode were scripted, such that it reduces the possibility for error while utilizing.