+ Reply to Thread
Results 1 to 4 of 4

Create outlook 2016 message using excel 2016 data

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    Chisinau
    MS-Off Ver
    Excel 2016
    Posts
    25

    Create outlook 2016 message using excel 2016 data

    Please help me with the following

    I have an xlsx file with 2 sheets (Sheet1 - list with contacts, list 2 - the text).

    I need a macro which would create a new outlook message with the following parameters:
    to: the email address from the active cell
    body: the text from sheet 2 which also contains a table (it's important the table to be in the message body below the text from Sheet2.A3).

    I found the code mentioned below but it does not work when I'm adding Worksheets("sheet2").Range("a6:e10") (Run-time error '13'/ Type mismatch)

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    The file is attached
    Attached Files Attached Files
    Last edited by Cephei; 10-29-2021 at 08:50 AM.

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

    Re: Create outlook 2016 message using excel 2016 data

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

  3. #3
    Registered User
    Join Date
    05-31-2013
    Location
    Chisinau
    MS-Off Ver
    Excel 2016
    Posts
    25

    Re: Create outlook 2016 message using excel 2016 data

    Quote Originally Posted by dangelor View Post
    Possibly...
    Please Login or Register  to view this content.
    Thank you very much. It worked

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

    Re: Create outlook 2016 message using excel 2016 data

    Glad to help. Thanks for the rep!

+ 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: 0
    Last Post: 11-20-2019, 04:05 AM
  2. Macro to create multiple accounts in Outlook 2016
    By nobleprince in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2018, 11:32 AM
  3. [SOLVED] No value given for one or more parameters - Access 2016 - Excel 2016
    By schulzy175 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2018, 10:11 PM
  4. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  5. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  6. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  7. Copy /paste excel data with mouse over comments to outlook 2016.
    By Rakeshkrishnan01 in forum Excel General
    Replies: 3
    Last Post: 06-28-2017, 02:24 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