We help IT Professionals succeed at work.

Mail merge to email(outlook) individual letters to multiple recipients with cc

388 Views
Last Modified: 2017-06-01
I have excel data that I use to complete a letter via mail merge.  I then need to create an email and attach letter or paste as an image and send to multiple recipients with a cc as well.   As I have 160 letters, Iam not sure if it is possible to do all that automatically?  I can create VBA in excel to open new mail, add to and cc contacts, fill in subject line and enter text in body.  I could attach file but mail merge creates one file.  I tried word mail merge, but a lot of formatting to get the letter looking professional in the body of email and it will only do one email contact, no cc.  Any help would be great, not sure if I'm wasting time on something that's not possible
Comment
Watch Question

Retired
CERTIFIED EXPERT
Top Expert 2012
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Thanks didn't think about approaching in 2 steps.  So the above separates the individual letters.  When I then complete the second piece in excel, is there a way to reference a specific file name to be added in each email?
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
The macro above extracts the unique data (e.g. recipient) which is used for the file names from a particular position in the letter. (I arbitrarily chose it to be the text before the first tab character.) You could match the file names to the list of recipients.

Author

Commented:
Thanks for the assistance with the code and approach to my problem.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions