View Single Post
  #3  
Old December 13th, 2015, 12:31 PM
Emilien Klein Emilien Klein is offline
Member
 
First recorded activity by OfficeFrustration: Dec 2015
Posts: 1
Thumbs up

Hi DLEESE04,

If you only need to CC one specific person each time, you could create an Outlook rule that goes like "CC this address on all outgoing email", and only activating it when you need to send these email merges. If your need is not more complex, that should do it.

I had the need to send emails out with varying folks in CC, and myself in BCC as part of my Getting Things Done work method, and (just as Doug Robbins solution posted by Peter Jamieson) was pointed to VB code. If you're OK with working with code, no need to read my answer further!

As I don't believe most office folks are OK working with code, I ended up making my own tool EmailMerge.cc . Let me know if that solves your issue too: http://emailmerge.cc/

For now it uses just a plain text file or an HTML file if you need formatting (not a Word document yet, but that will come soon) and the data from your Excel file.
That way you can send the emails out and CC your colleague as well.

Let me know if that helps.

Cheers,
Emilien

P.S.: My intent is not to dig out an older post, but to provide an easy solution to DLEESE04's problem. And since there was only one answer to this post, but this page is ranked high on the search engines, I suppose others with the same problem might find this tool helpful.

Last edited by Emilien Klein : December 13th, 2015 at 12:38 PM.