+ Reply to Thread
Results 1 to 2 of 2

Mass Emailing based of column values: Email, Subject, File

  1. #1
    Registered User
    Join Date
    05-15-2015
    Location
    Montana
    MS-Off Ver
    2010
    Posts
    0

    Mass Emailing based of column values: Email, Subject, File

    I have an excel work book that has a list of emails in A, a list of subjects in column B and a list of different files that need to be attached to their respective emails in C. I would like to create a macro that goes line item by line item creating a new email for each line item, using the different information from each line item. The only piece of information that would be the same for every email would be the body. Unfortunately this is beyond me expertise.


    Thank you in advance for you help!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello GingerMountain,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Need help adding the file name as the subject in an email sent from Excel
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2014, 12:44 PM
  3. [SOLVED] How to add an email attachement to VBA Mass Email by referencing file name in column
    By XCL88 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-10-2014, 06:20 AM
  4. HELP PLease:Mass Email from addresses in excel file
    By knevil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2013, 05:54 PM
  5. Email Macro: File Name Is Subject
    By SamuelT in forum Excel General
    Replies: 3
    Last Post: 11-10-2006, 11:54 AM

Tags for this Thread

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