• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

Help with MailMerge using Word, Excel and Outlook 2010

This started out seeming fairly easy, and now I see I am probably in over my head.  I want to have an end product which will send out a different document to multiple people through outlook.  I found a very helpful explanation of how to do this on EE:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/A_9210-Idiot%27s-Guide-to-Doug-Robbins%27-tool-Mail-Merge-to-E-mail-with-Attachments.html  by user coachjim .  This article points to Doug Robbins' macro at:


This seemed perfect for me.  I am not a programmer and don't need to become one.  I got this working but it doesn't send out the attachments.

Help on this would be appreciated.  My Boss wants this mailing to over 150 people to go out this week.

I've attached the test file I used from excel and the test file from word.  The excel file is used in word to generate the word test file.  The I used the macro from Robbins.  All of the addresses in the test file are mine.  I get an alert from Outlook but it won't let me say allow until it is nearly done.

Templates and screen capture are attached.
Thomas Zucker-Scharff
Thomas Zucker-Scharff
  • 3
  • 2
1 Solution
So far I've only read your question and looked at the screenshot of the Outlook warning. To get past the warning...

In Options/Trust Center/Macro security
1. Choose the option for notification for all macros
2. check the option to apply macro settings to add-ins.
Thomas Zucker-ScharffSystems AnalystAuthor Commented:
I would like to award points to an expert that didn't participate in this question but nonetheless solved the problem (through the messaging interface). Can that be done?
Ask the person who replied thru the messaging interface to post in the thread, then you can award them the points.
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Thomas Zucker-ScharffSystems AnalystAuthor Commented:
I will - thanks
Thomas Zucker-ScharffSystems AnalystAuthor Commented:
Since Nick67, who solved this problem through the messaging system didn't post here (even after I suggested it), I am awarding points anyway.

For the solution nick and I came up with see my article:
No Problem
I've been buried and points aren't the end of the world.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now