+ Reply to Thread
Results 1 to 3 of 3

Copy an image and range of text from Excel to Outlook mail body

  1. #1
    Registered User
    Join Date
    02-19-2020
    Location
    Berkshire
    MS-Off Ver
    365
    Posts
    2

    Copy an image and range of text from Excel to Outlook mail body

    Hi,

    I'm new to this forum so please be kind.

    I have been desperately searching for some VBA code where i can copy a range in an excel sheet which includes an image and text and paste into an the outlook email body. All the code i have found i can only paste the 'text' in the range or an image but never both. Any help is gratefully received!
    Attached Files Attached Files
    Last edited by ARance077; 05-14-2020 at 08:45 AM.

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Copy an image and range of text from Excel to Outlook mail body

    Go to View. . . "Page Layout"

    Highlight your range, copy, paste onto Outlook.

    If it works, try recording your keystrokes to develop a code, being sure to copy from the page layout view where it'll pick up your desired elements from the worksheet. Worked for me.

    Pete
    Last edited by PeteABC123; 05-13-2020 at 05:04 PM.

  3. #3
    Registered User
    Join Date
    02-19-2020
    Location
    Berkshire
    MS-Off Ver
    365
    Posts
    2

    Re: Copy an image and range of text from Excel to Outlook mail body

    Thanks Pete. Unfortunately the record function doesn't record your key stokes outside of excel so does not pick up opening outlook and pasting.

+ 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. Need to copy the Full data (Body) from Outlook Mail Box(specified Folder)
    By narendra.kilari in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2016, 07:17 AM
  2. [SOLVED] How to copy table from Outlook mail body in to text file
    By Draconi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2013, 02:43 AM
  3. Excel VBA outlook - Range in mail body
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 06:33 AM
  4. [SOLVED] filter and copy from excel into an e-mail (Body text).
    By Robert110 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-12-2013, 05:18 AM
  5. sending mail in outlook with image in Top center of body .
    By yogananda.muthaiah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2012, 05:06 PM
  6. Send e-mail with image on body (.html) on e-mail manager <> outlook
    By mariotnc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2012, 09:28 PM
  7. Replies: 7
    Last Post: 08-11-2012, 02:39 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