+ Reply to Thread
Results 1 to 10 of 10

Copy Data from Excel into Outlook Email

  1. #1
    Registered User
    Join Date
    09-25-2003
    Posts
    27

    Smile Copy Data from Excel into Outlook Email

    Dear All

    Thanking you all for taking the time to read my post and helping in any way.

    I need to copy rows from a spreadsheet where the date is equal to today.

    For example:

    Date Started Employee Name Probation End Date Success/Fail Email Notification
    25/03/2018 Sue 23/06/2018 Success date email sent
    26/03/2018 Lisa 24/06/2018 Success date email sent
    25/04/2018 Tina 24/07/2018 Success date email sent
    30/05/2018 Lenny 28/08/2018 Success date email sent

    In column 3 I have added the formula =A2+90 - (90 is to work out date 3 months from Start of Employment date).

    Then I need to add a command button with coding that will look at the date in column 3 and compare it with todays date.

    If date in column 3 is equal to today - then that row(s) to be copied and pasted into a blank outlook 2013 email.

    I am able to add body of email and recipient details but have no idea how to create a macro to work out which rows to paste.

    I thank you all once again for reading this post and any help/advice you can provide me with.

    Your faithfully

    Sue

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Copy Data from Excel into Outlook Email

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    09-25-2003
    Posts
    27

    Re: Copy Data from Excel into Outlook Email

    Dear Dflak

    Thank you for your valued advice and guidance.

    I have attached a working sample file with notes on the 2nd sheet for more guidance.

    I hope this makes sense to you.

    Kind Regards
    Sue
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-25-2003
    Posts
    27

    Re: Copy Data from Excel into Outlook Email

    Hi

    I have also attached an image of what the emails need to look like for your perusal.

    Kind Regards
    Sue

  5. #5
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Copy Data from Excel into Outlook Email

    I just did something very much like this. I'll have to dig it up. I will be out of pocket for a couple of days, so I ask your patience.

  6. #6
    Registered User
    Join Date
    09-25-2003
    Posts
    27

    Re: Copy Data from Excel into Outlook Email

    Dear Dflak

    Thank you for letting me know.

    I await your response and help with much anticipation.

    Kind Regards
    Sue

  7. #7
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Copy Data from Excel into Outlook Email

    I think I have what you want.

    Rows 1 & 2 are for testing. Blank out cell B2 and hide these rows and you have a working model.

    Column G is a "helper column" and can be hidden.

    A row is due mailing if Date Left is blank and the date in Column C is <= today's date
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    09-25-2003
    Posts
    27

    Re: Copy Data from Excel into Outlook Email

    Dear Dflak

    Thank you for your quick response to my query.

    When I test your Send Mail button I get a debug error and the following line of code is highlighted: If Range("Table_Data").SpecialCells(xlCellTypeVisible).Rows.Count = 0 Then

    Any guidance you can give me please?

    Thanking you heartily once again.

    Regards
    Sue

  9. #9
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Copy Data from Excel into Outlook Email

    Let' see if this version fixes the issue. Instead of checking to see if there is mail to send in the code, I put a helper cell on the Table to Mail sheet and check against that.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    09-25-2003
    Posts
    27

    Re: Copy Data from Excel into Outlook Email

    Hiya

    Thank you for the attached.

    I will take a look and come back to you.

    I am away for the next few days but will definitely let you know how I get on with your amended file.

    Many thanks for your help once again.

    Kindest regards
    Sue

+ 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. Use a macro to copy data from Outlook email to Excel workbook
    By Santhoshhrishi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 12:36 AM
  2. Replies: 1
    Last Post: 09-16-2014, 05:01 PM
  3. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  4. Copy Range of Data from Excel into Outlook Email
    By Vlade777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 10:07 AM
  5. Copy data from excel to Outlook new email and create draft.
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2013, 03:31 AM
  6. How to parse data in Outlook email using HTML version of email back to excel
    By bnasty in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-31-2012, 02:54 PM
  7. Replies: 2
    Last Post: 08-01-2012, 02:47 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