+ Reply to Thread
Results 1 to 9 of 9

Sending mail macro to multiple addresses

  1. 08-18-2012, 04:39 PM #1
    Raju Radhakrishnan
    Raju Radhakrishnan is offline
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Sending mail macro to multiple addresses

    Hi,

    I need a macro which would send a macro to multiple addresses. The body of the mail will be the same..I want the macro to give me an option to type what should be mentioned in from column, to column...Subject and body will be the same throughout...There are multiple id's in which the mail should be sent so I need an option to select multiple users at a time..if possible let me know then i will give you the subject as well as the body of the mail...
    Reply With QuoteRegister To Reply
  2. 08-20-2012, 03:48 PM #2
    Raju Radhakrishnan
    Raju Radhakrishnan is offline
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Sending mail macro to multiple addresses

    No one to help yet
    Reply With QuoteRegister To Reply
  3. 08-20-2012, 04:08 PM #3
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Sending mail macro to multiple addresses

    there are plenty of examples....
    try this one, in column A (email addresses), column B(body), column C (yes or no), cell D1(subject)
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-
    Reply With QuoteRegister To Reply
  4. 08-21-2012, 08:35 AM #4
    Raju Radhakrishnan
    Raju Radhakrishnan is offline
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Sending mail macro to multiple addresses

    This is good...But it doesnt automatically send it to the adresses...we have to click on send in outlook again and again. So can you please amend it accordingly so that it would send directly? Thanks...

    (Note : If heading wouldnt be there then my users wont know where n what we have to fill in)
    Last edited by Raju Radhakrishnan; 08-21-2012 at 08:39 AM.
    Reply With QuoteRegister To Reply
  5. 08-22-2012, 08:31 AM #5
    Raju Radhakrishnan
    Raju Radhakrishnan is offline
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Sending mail macro to multiple addresses

    And also I want to change the FROM column. rest all superb
    Reply With QuoteRegister To Reply
  6. 08-22-2012, 09:42 AM #6
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Sending mail macro to multiple addresses

    Please have a look and you'll see a note near .Display, it means replace it with .Send, it will send the email(s) automatically.
    Reply With QuoteRegister To Reply
  7. 08-22-2012, 01:31 PM #7
    Raju Radhakrishnan
    Raju Radhakrishnan is offline
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Sending mail macro to multiple addresses

    Hi,

    I have attached the macro file. I need this to be amended appropriately.

    1) When i added headings... Subject column is showing as subject in mail.

    2) I want the from column to be xxxx (I want to add a name which is confidential)

    Rest all fine and thanks for replying
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 08-22-2012, 02:07 PM #8
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Sending mail macro to multiple addresses

    try this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 08-22-2012, 04:08 PM #9
    Raju Radhakrishnan
    Raju Radhakrishnan is offline
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Sending mail macro to multiple addresses

    That worked. One thing i want is FROM...Its still showing as Raju Radhakrishnan. I want that to be edited. possible?
    Reply With QuoteRegister To Reply
  10. 08-22-2012, 04:56 PM #10
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Sending mail macro to multiple addresses

    As far as i know "From" comes from yr settings of outlook!
    I am sorry, I can not help you!

    Have a nice evening!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1