Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2007-11-27
3
574 Views
Last Modified: 2010-04-21
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.. http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_22986020.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.
0
Comment
Question by:Nmagsaysay
3 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 20401271
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.
0
 
LVL 1

Accepted Solution

by:
virgo71il earned 500 total points
ID: 21180327
Nmaqsaysay,

I use this software all day long to do just what you asked for.  It's wonderful.  http://www.software-solutions.co.nz/aladdins_od/alodabout.asp
0
 

Author Closing Comment

by:Nmagsaysay
ID: 31411290
Thanks this works very well!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question