Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    120
    Thanks
    3
    Thanked 2 Times in 2 Posts

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

    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

  2. The Following User Says Thank You to bobchapman For This Useful Post:

    dweebken (2015-06-17)

  3. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    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.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    120
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Found a solution

    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
    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.
    About

    Development

    • Wouter Westerveld, Lead Developer
    Questions, Ideas, Bugs

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

  5. The Following User Says Thank You to bobchapman For This Useful Post:

    dweebken (2015-06-17)

  6. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Bob,

    Glad you got it sorted.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #5
    New Lounger
    Join Date
    Dec 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    OMMA Script Error Message

    Quote Originally Posted by bobchapman View Post
    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

    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.

    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

Posting Permissions

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