asked on

How to automate the create letter merge from contact in outlook.

I looking for a way to mimic the one click create letter feature found in ACT. I'm using using Outlook 2003 and I would like a simple way to create letters to outlook contacts. I find that Microsofts soultion is not simple. Users complain about the number of steps. ( http://www.outlook-tips.net/howto/mailmerge.htm) Is there a way to simplify the process using a macro? In the end I would like to open outlook, select a contact or contacts, & click button on the toolbar that starts the merge.

Here's Microsoft's lengthy instructions.. https://www.experts-exchange.com/questions/22986020/How-to-automate-the-create-letter-merge-from-contact-in-outlook.html

How do I simplify this process? I would be happy with a 1 or two click process. Is this something that is possible, or is there no soultion to my requests? I'd even be happy to purchase a 3rd party solution. (except ACT -lol)

Thank you for your responses.

Jason C. Levine

Hi Nmagsaysay,

There really isn't a better or faster way to create a mail merge using Outlook contacts as the source. People use ACT precisely to avoid using the MS solution.

You could play around and generate a macro that does some of the initial click for you, but this isn't a good use of developer time. You're better off creating the form letters and saving them and allow each user to filter their contacts and send the result to the doc to be merged.

ASKER CERTIFIED SOLUTION

virgo71il

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nmagsaysay

ASKER

Thanks this works very well!