+ Reply to Thread
Results 1 to 4 of 4

Sending Emails based on content in a single cell

  1. #1
    Registered User
    Join Date
    03-09-2017
    Location
    Monrovia
    MS-Off Ver
    2013
    Posts
    57

    Sending Emails based on content in a single cell

    Hi,

    I have been trying to find a way to send a mail using the mail template that I have in cell C10 and the email list I have from row 7 Column C onwards.
    email test.JPG

    I was trying initially using strbody, but I would rather not change the code again and again just to change the contents of mail. So is there a way where I can select .To and .Body from the contents present in cell?

    This is the code I'm using:

    Please Login or Register  to view this content.
    Last edited by chunkyp; 09-13-2017 at 06:30 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Sending Emails based on content in a single cell

    For the body use

    Please Login or Register  to view this content.
    Is there a reason why you're using ROW instead of Column for the mail to recipients?
    Column would be more simpler to use

    Please Login or Register  to view this content.
    This code above can be used to handle Cc & BCc

  3. #3
    Registered User
    Join Date
    03-09-2017
    Location
    Monrovia
    MS-Off Ver
    2013
    Posts
    57

    Re: Sending Emails based on content in a single cell

    Thanks Syrkrasi.. This worked perfectly..

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Sending Emails based on content in a single cell

    You're welcome

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Also if I solved your request, please press the Add Reputation button in the lower left-hand corner

    Cheers

+ 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] Sending Emails based on Check Boxes
    By rwl123456 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2017, 02:45 PM
  2. [SOLVED] Sending Mass Emails on Just Single Click
    By E5254730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2016, 12:22 PM
  3. Replies: 2
    Last Post: 12-19-2014, 11:28 AM
  4. Sending emails based on two spreadsheets
    By VORT8019 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2014, 11:06 AM
  5. [SOLVED] Sending two different emails to two different recipients with single button using vba
    By ahowe in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-23-2013, 08:28 PM
  6. Sending email based on cell content
    By Hoosteen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2007, 02:08 PM

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