Results 1 to 2 of 2

VBA to Paste Table from Excel into Outlook Message and Create Subject.

Threaded View

  1. 09-28-2021, 11:41 AM #1
    thbutterflycollector
    thbutterflycollector is offline
    Registered User
    Join Date
    12-09-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    9

    VBA to Paste Table from Excel into Outlook Message and Create Subject.

    Hello,

    Torachan has very kindly helped me with a VBA to save as a PDF with a file name but I'd also like to copy the contents of a excel worksheet and paste into the body of an outlook message with a subject. I'm not to concerned whether it is a jpeg or not but at the very least I would like to maintain the formatting.

    I've created a control button (Send to Email) and the Subject is within W5 on 001.

    Can anyone kindly help?
    Attached Files Attached Files
    Last edited by thbutterflycollector; 09-28-2021 at 02:35 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA: Post Excel Table Contents into MS Office Outlook 2010 Message
    By josephyschen89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2018, 12:04 PM
  2. excel macro to create outlook message - with Private sensitivity
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2017, 02:22 AM
  3. [SOLVED] Paste Excel range into Outlook message body as picture
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2016, 05:49 PM
  4. Extract Subject and Body of an Outlook Message into Excel
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2016, 12:31 AM
  5. Cross reference Outlook message subject with Excel list.
    By Karl Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2014, 10:12 AM
  6. Automatically Create Outlook Task When Value <50 using adjacent cell as subject/title
    By indiegoober in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2013, 10:17 AM
  7. Substitute bookmarks/subject from Outlook message from Excel rows/cells then loop
    By nylevolm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2013, 11:02 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1