+ Reply to Thread
Results 1 to 2 of 2

Macro to send an email to more that one email address in the same row

  1. #1
    Registered User
    Join Date
    12-02-2013
    Location
    Miami
    MS-Off Ver
    Excel 2010
    Posts
    89

    Post Macro to send an email to more that one email address in the same row

    Hello All,

    This is what I require. Example:

    I have an Excel sheet with several columns. Each row contain information about an specific client. Each row contain 2 email addresses (client and Secondary contact). Once the macro runs this is what it will be required.

    1 - Create email to be sent at once to the 2 email address in the same row, in different columns. (instead of sending the email automatically, I want to display it first)
    2 - As an attachment it will have to create a new Excel document with row 1 and the row according with the 2 email address.
    3 - Set the subject always to be the same (Ex: Notification .....)
    4 - In the body message, it will start with HELLO , I would like for the name of the client to be put automatically after that
    5 - The email will contain the same body message (EX: This is a test ....)
    6 - Is there a way to setup an signature (EX: NAME, PHONE)

    Thank you so much in advance. I would appreciate all the help
    Last edited by eddyrcabrera79; 05-11-2015 at 01:56 PM.

  2. #2
    Registered User
    Join Date
    12-02-2013
    Location
    Miami
    MS-Off Ver
    Excel 2010
    Posts
    89

    Re: Macro to send an email to more that one email address in the same row

    Please Login or Register  to view this content.

+ 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. [SOLVED] creating a macro that inserts the current date in the same cell everytime the macro is run
    By katie1994 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2012, 07:59 PM
  2. help with macro - creating new columns/copying/creating new worksheets from default
    By vsantoro in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2010, 09:29 AM
  3. Creating a macro to auto-update external data and time macro was excecuted
    By UNWATCHABLE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2010, 05:21 AM
  4. Replies: 3
    Last Post: 12-15-2009, 10:22 AM
  5. Creating a macro which presses a button containing a recorded macro
    By petros89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2005, 10:05 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