+ Reply to Thread
Results 1 to 3 of 3

Button to Send email & auto add email address from cell

  1. #1
    Registered User
    Join Date
    10-10-2019
    Location
    UK
    MS-Off Ver
    2013
    Posts
    15

    Cool Button to Send email & auto add email address from cell

    Hi there, wonder if anyone can help.

    I am looking to get out 3 functions from sending email from Excel.

    1: A Button to send either a new email with set text in the body & subject OR open a template email saved in a folder on computer.
    2: Auto enter the email address based on the value of a cell.
    3: Auto enter their name based on the value in a cell.


    Is ths possible?
    Thank you
    James

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    excel 2016 64bit - Windows 10
    Posts
    2,056

    Re: Button to Send email & auto add email address from cell

    All possible but it would be easier to work with a copy of your workbook. Do you need to send as an attachment or as a pdf file??

  3. #3
    Registered User
    Join Date
    10-10-2019
    Location
    UK
    MS-Off Ver
    2013
    Posts
    15

    Re: Button to Send email & auto add email address from cell

    Hi nigelog,

    Thank you for replying to me, I have been on holiday, which is why I haven't updated the post.

    Anyway I have attached the sheet this time (which I thought I'de done in the first place).


    After re-looking at the sheet I'm not sure how it would actually work as I haven't fully explained what I want.


    1: The sheet is for fitness plans & there will be multiple people editing so want to reduce the chances of mistakes.
    2: There are 4 contact point dates where we follow-up with the client (week2, week6, week12 & week24).
    3: Ideally I want a button at the top of the column for that follow-up date that will auto create a new email with certain text in OR open a template email on the shared drive.
    4: Ideally it will auto-emter enter the name & email address of the person we are currently dealing with (but that is where it probably becomes a pain in the backside to actualy sort out). If this can't be done then just a button in the column header to send new email (as in point 3)


    Thank you for your time.
    James
    Last edited by TheNerdyGeek; 10-24-2019 at 03:14 PM. Reason: to explain in more detail

+ 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] vba email send from excel - ignore second email address if "ENTER EMAIL ADDRESS"
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2016, 07:22 AM
  2. [SOLVED] VBA to send email using data from the EXCEL including email address, subject and body text
    By ec4excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2016, 11:07 AM
  3. rule to send an email alert to another email address
    By wayneg in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 02-08-2016, 06:15 PM
  4. [SOLVED] Send email as To address to all email id stored in excel
    By santbiju1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2015, 03:03 AM
  5. VBA code to send email to the people whose email address is in the Access table
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2014, 05:11 AM
  6. Auto send email with the cell value that triggered the email in the first place.
    By coobey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 05:40 PM
  7. Replies: 6
    Last Post: 12-02-2011, 02:14 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