+ Reply to Thread
Results 1 to 2 of 2

VBA Mailto: Sending a body of email from the list of people

  1. #1
    Registered User
    Join Date
    05-16-2018
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    6

    Exclamation VBA Mailto: Sending a body of email from the list of people

    Hello everyone,

    Please see the attached [VBA HELP.XLSX] document.[List] tab column A and B contains the list of 'To' email list. Column C contains 'Send Link' hyperlink which I originally had 'mailto' function.

    The process should be that the EA need to click hyperlink on column C line by line to send an email (we want to keep it this way).
    So when she clicks C3, it will send an email to A3 and AB. The body of the email is from [Email] tab.

    I am completely new to VBA and have no idea how to create a VBA code. I came across Ron de bruin website, but no luck at all.

    If you could help me, that would be great.
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,849

    Re: VBA Mailto: Sending a body of email from the list of people

    Into Module:

    Please Login or Register  to view this content.
    and into Sheet 'List' code:
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. Sending Email with Email body in a cell keeping the formatting.
    By VBA_N_O_O_B in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2017, 11:35 PM
  2. [SOLVED] sending email with specific details in body of email
    By murray83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2017, 10:31 AM
  3. Search & Replace in email body when sending an email with Excel
    By DreamEyes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2016, 07:52 AM
  4. [SOLVED] sending email with specific range as email body vba modification
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2014, 11:24 AM
  5. [SOLVED] sending email with a Picture in the body
    By kiranpat in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-22-2014, 08:31 PM
  6. [SOLVED] Sending email to different people based on the value in a cell
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2013, 11:53 AM
  7. Multi line email body from HYPERLINK CONCATENATE MAILTO?
    By JRR007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2012, 08:18 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