+ Reply to Thread
Results 1 to 8 of 8

Send email from Excel_'To address' not in excel_Copy & Open email template

  1. #1
    Registered User
    Join Date
    10-03-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    98

    Send email from Excel_'To address' not in excel_Copy & Open email template

    Hello All,

    I'm not a coding expert and so looking for someone to help me. First of all, thanks for taking time and reading my requirement.

    Requirement: I have some contents in the excel file (as shown in screenshot1) and with a click of button, I want an email to be opened with copying of excel contents into the body of the email as shown in 2nd screenshot.

    Things to be noted:
    1. After clicking button (running VBA script), email with excel contents to be opened but not directly send. To address and Subject are NOT mentioned in the excel file. Just open the new email with excel contents pasted into the body of the email
    2. I want this NOT as an image, can excel copy the contents and paste it into the email?
    ******** From Cell C2 to D25. Also, please also check below point (#3).
    3. There are chances that the table which I'm showing in screenshot is not fixed. Additional columns and rows can be added. Maybe this always starts from cell-C2 but high chances of adding more Columns and Rows to it. Can this table be dynamically copied and pasted? by adjusting the table borders into the email?? [Important but not a mandatory requirement].

    Send Email.PNG
    Expected Output_Email Generation.PNG

    I'm attaching the sample worksheet for your convenience. Request to please work on this worksheet and send it back to me. Thanks a ton in advance!!

  2. #2
    Forum Contributor
    Join Date
    04-16-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    216

    Re: Send email from Excel_'To address' not in excel_Copy & Open email template

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Send email from Excel_'To address' not in excel_Copy & Open email template

    Possibly...
    Please Login or Register  to view this content.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Send email from Excel_'To address' not in excel_Copy & Open email template

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  5. #5
    Registered User
    Join Date
    10-03-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    98

    Re: Send email from Excel_'To address' not in excel_Copy & Open email template

    Thank you very very much @Cobra17!!

  6. #6
    Registered User
    Join Date
    10-03-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    98

    Re: Send email from Excel_'To address' not in excel_Copy & Open email template

    Thank you very very much @Dangelor!!

  7. #7
    Registered User
    Join Date
    10-03-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    98

    Re: Send email from Excel_'To address' not in excel_Copy & Open email template

    Thank you very very much @Mumps1!!

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Send email from Excel_'To address' not in excel_Copy & Open email template

    Glad to help.

+ 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] Email Send Macro - 0 pulling into CC field when no email address present
    By toriwoo86 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-26-2021, 02:18 PM
  2. Button to Send email & auto add email address from cell
    By TheNerdyGeek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2019, 02:43 PM
  3. [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
  4. [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
  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. Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  7. How prevent email address from being hotlinked to open send msg wi
    By John in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2006, 06:40 PM

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