+ Reply to Thread
Results 1 to 5 of 5

Copy data from Excel 07 and paste it into an Outlook 07 email template

  1. #1
    Registered User
    Join Date
    04-05-2017
    Location
    Pittsburg Ca
    MS-Off Ver
    Excel 2007
    Posts
    13

    Copy data from Excel 07 and paste it into an Outlook 07 email template

    Hello All,

    Question: Is there a way to copy a range from Excel as a table and insert the table into an outlook email template? Or any other options so the text can be copied and pasted from the email?

    Details:
    I'm working with Excel 07 & Outlook 07.

    I have workbook we use to email order & tracking info to our customers (semi-automated process). It works, but the tracking information in the body of the email is an image, so our customers are unable to copy and paste the tracking numbers.

    I have an Excel work book that when closed it uses Macros to find what ever row has Today's date, sorts, copies and pastes those rows into a temp sheet. It then copies that range of cells in an image format so that can be pasted into an outlook 07 email template. Since the range is inserted as a image, our customers are unable to copy and paste the tracking numbers from the image.



    Link to old thread with more details about my project: https://www.excelforum.com/excel-pro...omer-name.html
    Please Login or Register  to view this content.


    Thank you,

    Dan
    Attached Files Attached Files
    Last edited by manieldunk; 06-21-2018 at 02:02 PM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Copy data from Excel 07 and paste it into an Outlook 07 email template

    .
    First .. keep in mind I did not review your workbook or your posted code.

    Based on your request to insert the values (used range) of the temp sheet into the body of the email without it being a picture so the recipient can copy any data they desire,
    please refer to this code.

    Please Login or Register  to view this content.
    To test the code, paste it into a Routine Module. Create some dummy data into any sheet. Place a Command Button on that sheet connected to the COPY ROWS macro. Run it.

    With your project, instead of creating a temporary sheet, I presume of unknown name, have your project always paste your data to a sheet named EMAIL or something similar. Place the Command Button on the EMAIL sheet for sending
    your data.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-05-2017
    Location
    Pittsburg Ca
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Copy data from Excel 07 and paste it into an Outlook 07 email template

    Thank you for the help!I ended up figuring it out. If anyone is interested in how I did it, send me a private message.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Copy data from Excel 07 and paste it into an Outlook 07 email template

    .
    Glad you got it going !

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Copy data from Excel 07 and paste it into an Outlook 07 email template

    Good for you Dan...just got too busy with all the rain, lawn work, spring cleanup, outside work, Family coming in this weekend...great job.
    I'd suggest you share your solution on your Thread...it'll help others.
    John

    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.

+ 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. Replies: 1
    Last Post: 10-12-2017, 12:51 AM
  2. Copy word document and Paste it as body of Email in Outlook (using VBA from Excel)
    By Asacras in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2017, 10:23 AM
  3. Open excel attachment from email in Outlook and copy and paste into workbook
    By RubiksCuber in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2016, 10:26 PM
  4. Copy and paste Excel range as picture into Outlook email body using excel vba
    By ExcelDoc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2016, 09:29 PM
  5. Is there a way to Copy And Paste Excel Range As Picture Into Outlook Email Body Using Exc
    By dineshsachidananda in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2014, 09:00 AM
  6. Copy paste a table in outlook email to excel
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2012, 04:41 AM
  7. Copy- paste from Excel to Outlook Express email
    By JERRY in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 11:54 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