+ Reply to Thread
Results 1 to 1 of 1

HELP PLease:Mass Email from addresses in excel file

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    Ottawa
    MS-Off Ver
    Excel 2010
    Posts
    22

    HELP PLease:Mass Email from addresses in excel file

    Hi,

    I have to send vendor manuals out to over 1000 vendors. I have a spread sheet with their email addresses in column C. I have two email templates with the vendor manuals attached in the template.

    For each template I would like to sort by Vendor # (column A), concatenate all emails under said vendor # (column C, up to 5 addresses) and input the address into the .To field of the email sub.

    Is there a way to create this type of macro? I have attached the excel file that contains all vendors email address.

    Any Help with this would be much appreciated.
    Attached Files Attached Files

+ 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. Mass email a column of email addresses?
    By bmblack in forum Excel General
    Replies: 3
    Last Post: 09-30-2015, 03:06 PM
  2. excel file and throw out email addresses
    By Thomas_xyz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2012, 03:43 PM
  3. email excel file or worksheet as an attachment to multiple email addresses
    By jgeagle5 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2009, 03:40 PM
  4. Sending an email from Excel to multiple email addresses
    By insanity66 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2009, 02:01 PM
  5. [SOLVED] Email addresses in Excel need to format for mass email
    By Boomer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2006, 08:50 AM

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