+ Reply to Thread
Results 1 to 3 of 3

Pasting Excel Table into Body of Outlook reply

  1. #1
    Forum Contributor
    Join Date
    11-21-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    376

    Pasting Excel Table into Body of Outlook reply

    I know I am realllllllly close to getting this to work.

    The problem that I am having is revolving around the code
    Please Login or Register  to view this content.
    Basically what the whole process will be is a Rule runs in Outlook and when a specific email comes in the attachment is saved in the the TPS Reports folder, then opened.... and then a couple vlookups are run on that attachment against data saved in the workbook VBDCdata.xlsx.

    Then I need the data from the attachment after the vlookups have been run to be copied and pasted into the body of a reply email to the original senders.

    I have this working in a text format only.... but i need that actual table format from excel. I am thinking that the error is coming from a problem with variable declarations, but not sure what it should be declared as if it should be declared?

    Full code that is in outlook is below. Any help is appreciated.



    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,081

    Re: Pasting Excel Table into Body of Outlook reply

    I just had to solve this issue myself. I cleaned it up and here it is. The code is in ModMailRange and I have it in a sample workbook to show how it is used. I also set up a macro to "feed" the mail program. You should be able to adapt your code to feed the mailer as well.

    In this example, I want to show the table in columns A & B and the chart next to it. Both of these are covered by the range A1:J13. The program takes a picture of the text and data in the indicated range.

    I will leave it to you to come up with your own attachment. Attachments are optional.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor
    Join Date
    11-21-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    376

    Re: Pasting Excel Table into Body of Outlook reply

    Thank you!

    i should have replied to this as I was able to figure out a solution as well
    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. Replies: 0
    Last Post: 05-28-2018, 09:53 AM
  2. Replies: 1
    Last Post: 09-16-2014, 05:01 PM
  3. [SOLVED] Pasting Range of Cells into Outlook with Other Text in Body?
    By bryanmarks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2014, 05:33 PM
  4. Run-Time Error 4065 - Pasting Copied Data from Excel to Outlook Email Body
    By jtn260 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2014, 11:03 AM
  5. Pasting Table Autoformat into Outlook Email Body
    By frolicols in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2014, 11:30 AM
  6. Read/Export table from Outlook mail body to Excel using VBA
    By pradeepdeepu_001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2013, 06:48 AM
  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