+ Reply to Thread
Results 1 to 2 of 2

Macro to create an outlook email with contents of various cells?

  1. #1
    Registered User
    Join Date
    02-10-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    58

    Macro to create an outlook email with contents of various cells?

    Hi all,

    Trying to create a macro to create an outlook email using VBA. The email contents will be from a worksheet.

    The title will be from cell F6, and the body contents will be from cells K19, K20, and K21.

    I'm not familiar with how to do this, and would appreciate some help please.

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,681

    Re: Macro to create an outlook email with contents of various cells?

    Hi
    try this
    you will need to have the outlook object library checked under tools > references in the VBA area for it to work

    Please Login or Register  to view this content.

+ 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. Macro - copy contents of word doc to outlook email inc jpeg
    By sipa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2016, 10:14 AM
  2. Create macro to open daily email and Excel attachment from Outlook
    By wardpa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-02-2013, 10:26 AM
  3. [SOLVED] Macro to create a pdf and attach to an email (Outlook)
    By jsedore in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-01-2013, 03:16 PM
  4. Create macro to open daily email and Excel attachment from Outlook
    By uimhirADo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2012, 09:23 PM
  5. Replies: 1
    Last Post: 05-22-2012, 02:13 PM
  6. Macro to create a pdf of a range and send in an Outlook email
    By dzuspann in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2012, 01:53 PM
  7. Can't Create Macro for Excel to Email through Outlook
    By grosh83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2012, 05:50 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