+ Reply to Thread
Results 1 to 6 of 6

Excel data inside e-mail body

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    11

    Excel data inside e-mail body

    Hi all,

    I regularly receive e-mails from a manufacturer, and he is able to put what looks like Excel data INSIDE the body of the e-mail.

    example.JPG

    They write a normal e-mail, and among the text is set of columns and rows with text or number inside.
    I am able to highlight the content of it, meaning it is not a simple image.

    How to do this?

    Thank you in advance/

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Excel data inside e-mail body

    Copy-paste

  3. #3
    Registered User
    Join Date
    04-12-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel data inside e-mail body

    I tried it. Selected the data in Excel, Ctrl+C and Ctrl+V into Outlook, and it pastes the data in a different way:

    Huge gaps between the cells
    No lines visible (meaning no actual "cells" visible, just the written content

  4. #4
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Excel data inside e-mail body

    When you paste into Outlook, use Paste Special, then choose Microsoft Excel Worksheet Object

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Excel data inside e-mail body

    Cells in Excel by default are not formated.
    A thin blue line that you see in Excel is just gridline.

    Therefore you need first to format data in Rxcel and then copy paste to Outlook.

    Selected (blue) cells on the right and how they look in Outlook (left).
    You can see unformated cells (1,2,3,4) has no lines in outlook.

    Untitled.jpg

  6. #6
    Registered User
    Join Date
    04-12-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel data inside e-mail body

    Hi Zbor,

    Note: I actually use Outlook365, not the old MS Outlook. Maybe that's why it doesn't work like you do?


    [B]--> In Excel I always add cell outlines, meaning my cells have black lines around them, not thin blue lines.
    I copy and paste from Excel and it makes a mess of data, again with no black lines whatsover.

    example.JPG
    Last edited by Bellaggio1770; 05-31-2016 at 11:25 AM.

+ 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. How to add table in the body of the mail through excel.
    By Jagdev in forum Outlook Programming / VBA / Macros
    Replies: 9
    Last Post: 12-21-2014, 05:48 AM
  2. [SOLVED] Inserting an excel table in mail body
    By Raghukumarn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2014, 08:48 AM
  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. Replies: 1
    Last Post: 07-22-2012, 09:26 AM
  5. VBA code does not pastes data in the Mail Body
    By MacroMan82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2010, 11:19 AM
  6. [SOLVED] Formatting the user data for the body of the mail in excel
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-01-2006, 03:50 PM
  7. [SOLVED] Mailing an excel range in the body of an e-mail
    By Andy Tallent in forum Excel General
    Replies: 3
    Last Post: 07-20-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1