Can’t do mail/merge to Outlook and insert attachments???

Topic

New Reply

I need to send out a email to a bunch of people, with the bodyof the email personalize by using mail/merge from Word, and include attachments. Is this possible: I cannot find a way to do it.

I know how to do mail/merge from Word to emails. I also know how to send out an email to a bunch of people by copying their addresses into the bcc field (blind copy), but there’s no way then to personalize the text of the email.

I appreciate any guidance,
Bob

Reply | Quote

Replies

Bob,

What you want to do is doable but I think you’ll have to resort to VBA to accomplish the task. This thread may be of some help. You can also search the Lounge on the terms “Email”, “VBA” as I know there are several more detailed posts, including some of mine, on the topic. :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thanks for your response.
I’ve just found a non-VBA solution, which really means that someone else has done the VBA work, I suppose:

Outlook mail merge attachment (OMMA)Version 1.1.8 BETA, 2 December 2012
[h=2]Information[/h]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.
[h=2]Preparation[/h]

[*]Requirements

[*]Microsoft Word and Outlook, versions 2003, 2007 or 2010.
[*]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

[*]The zip-file containing Outlook Mail Merge Attachment can be downloaded from http://omma.sourceforge.net.

[/LIST][h=2]How-to[/h]

[*]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.

[/LIST][h=2]About[/h][h=3]Development[/h]

[*]Wouter Westerveld, Lead Developer

[h=3]Questions, Ideas, Bugs[/h]For any questions, ideas or bug-reports, please contact me at westerveld@users.sourceforge.net.

Reply | Quote

Thanks for your response.
I’ve just found a non-VBA solution, which really means that someone else has done the VBA work, I suppose:

Outlook mail merge attachment (OMMA)Version 1.1.8 BETA, 2 December 2012
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 or 2010.
[*]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

[*]The zip-file containing Outlook Mail Merge Attachment can be downloaded from http://omma.sourceforge.net[/COLOR%5D%5B/url%5D.

[/LIST]
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.

[/LIST]
About

Development

[*]Wouter Westerveld, Lead Developer

Questions, Ideas, Bugs

For any questions, ideas or bug-reports, please contact me at westerveld@users.sourceforge.net.

I downloaded the OMMA script today. First time I ran it, no problems. Now I am getting an error message, “You don’t have appropriate permission to perform this operation.” Any idea why I am getting this message? Thanks, Tony

Reply | Quote

Bob,

Glad you got it sorted. :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote