+ Reply to Thread
Results 1 to 5 of 5

Mail Merge Auto Email VBA - Multiple CCs.

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2016
    Posts
    14

    Question Mail Merge Auto Email VBA - Multiple CCs.

    Hi,
    I have an excel macro / spreadsheet that i use to mass emailing people. It has been re-purposed over the years for various functions, so, to be honest, there is lots of stuff in it that probably is not relevant to what I need now. I'm not the creator, though I've had to make some tweaks over the years.. but, i'm not a programmer.

    So, the script will take data from the tab "RFCs Not Closed", compile unique spreadsheets for each name in Column F, then create the email, attach the spreadsheet with the rows of data matching on Column F.
    So, in the attached example, I will get 1 email, addressed to jacob two-two, it will have a spreadsheet with the columns/rows of data that you can see on the first tab. It will email the email address in Column G.

    What I'm trying to do, is get it to CC the names in Column I, for every row of data. Right now, it will CC the first name it comes across "per name" in Column F. So, if I have 5 managers... I'll get 5 spreadsheets, with 5 emails. If a manager has say 10 rows of data, even if the CC name has 10 unique names for that manager, it will pick only the first one, and CC it. Hopefully this is making sense what I'm saying.

    Essentially, i want rows of data for the manager, and for it to CC all the users as well so they are aware the manager is being emailed (its for following up with outstanding training).
    I've attached the file (or hopefully I've attached it!)

    Can anyone help? Is this possible to do without having to re-write the whole script? The coding is on the object "sheet1 (RFCs Not Closed)". I'm sorry if this is a bit too much info provided, but I'm just not sure which function that needs to be modified.

    Rilly
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 01-22-2020 at 03:55 AM. Reason: Removed title part

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,121

    Re: Mail Merge Auto Email VBA - Multiple CCs.

    See if this works for you.

    I posted the whole sub so you can just copy and paste.

    Since the CC is just a text string, I build a unique list using a Collection, build a concatenated string, then post that to the Email sheet.

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    11-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2016
    Posts
    14

    Re: Mail Merge Auto Email VBA - Multiple CCs.

    Thank you Tinbendr! I will give that a try this week and see how it goes!

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    Canada
    MS-Off Ver
    Excel 2016
    Posts
    14

    Re: Mail Merge Auto Email VBA - Multiple CCs.

    i was finally able to test this today.. I see how it updates the cell with the list to cc, but, how do I get it to pull that into an email so that it is specific to the manager only.

    So, if there are 500 rows of data, and 10 different managers. When i run it, i'll get 10 different emails, and each email, will cc the users per manager.

    So, for example with just 2 managers..
    Jim is Brenda, Sarah, Mike and Dave's manager
    Patty is Rahim, Jerry, Bob and Heather's manager

    I would get 2 emails.. One to Jim, and one to Patty. The email to Jim will CC Brenda, Sarah, Mike and Dave, but the email to Patty will cc Rahim, Jerry, Bob and Heather

    Does that make sense?

  5. #5
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,121

    Re: Mail Merge Auto Email VBA - Multiple CCs.

    So, tell me how you operate this code.

    Which ones do you run to start the process?

    Should the code generate all ten manager's email in one run?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mail Merge to Email
    By NicoleAL123 in forum Word Formatting & General
    Replies: 7
    Last Post: 11-16-2017, 04:42 PM
  2. Mail Merge Directory - Creating merge with multiple lines
    By tiggynook in forum Excel General
    Replies: 3
    Last Post: 05-03-2017, 03:00 PM
  3. How to do a Mail Merge With CC Email
    By Kingswood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2015, 04:25 PM
  4. [SOLVED] Split mail merge letters and send email
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-03-2015, 11:21 AM
  5. Mail Merge and Send Fax via Email
    By Gos-C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2015, 03:31 PM
  6. [SOLVED] Excel sheet mail merge to email?
    By tavyabe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2012, 09:18 AM
  7. mail merge to email
    By newangel90 in forum Word Formatting & General
    Replies: 1
    Last Post: 12-10-2010, 12:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1