+ Reply to Thread
Results 1 to 10 of 10

How to add table in the body of the mail through excel.

  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    23

    Post How to add table in the body of the mail through excel.

    Hi Experts.

    I got a macro from the following google, but the issue is with the text in the body of the mail.

    In the current excel macro it is allowing only text to be used in the particular cell and display that in the mail body of my outlook.

    I have a table like the one in the below thread. Is it possible to add it in the cell and then in the mail body from there.

    Ref Ccy Amount Name Date
    1123245 US $1,045.00 ABC company 12/12/2014

  2. #2
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: How to add table in the body of the mail through excel.

    Without the code it is difficult to make a suggestion.

    You may find an alternate solution here.

    Mail Range or Selection http://www.rondebruin.nl/win/s1/outlook/amail4.htm

    Mail from Excel with Outlook (Windows) http://www.rondebruin.nl/win/s1/outlook/mail.htm
    To mark "Solved" go to Thread Tools.

  3. #3
    Registered User
    Join Date
    10-15-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    23

    Re: How to add table in the body of the mail through excel.

    Hi Skatonni,

    Please find the code below.

    I want the content in the body of the outlook look like the below form:

    Dear Sir ,

    We would like to wish you a Merry chirtmas & Happy New Year.

    Ref Ccy
    Date
    Organization



    Regards,

    Jagdev
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: How to add table in the body of the mail through excel.

    If for example, the data is in columns F to J

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-15-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    23

    Re: How to add table in the body of the mail through excel.

    Hi Skatonne

    Thanks for the code. I want this section to appear in tabular form. Could you please let me know how to add it in table. Would it be possible to add the data in tabular form and that to in the way I mentioned in my first post.

    Thanks in advance for your support.

    Regards
    Jaggi

  6. #6
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: How to add table in the body of the mail through excel.

    I assumed you rejected this code but just in case you missed it.

    http://www.rondebruin.nl/win/s1/outlook/bmail2.htm

    Put the headings and data into a temporary block then use this line

    Set rng = Sheets("YourSheet").Range("D4:D12").SpecialCells(xlCellTypeVisible)


    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    10-15-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    23

    Re: How to add table in the body of the mail through excel.

    Thanks it worked fine.

    Regards,
    JD

  8. #8
    Registered User
    Join Date
    10-15-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    23

    Re: How to add table in the body of the mail through excel.

    Hi Skattone

    I am curious to know can we change the table data/value in every mail.

    Regards
    Jaggi

  9. #9
    Registered User
    Join Date
    10-15-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    23

    Re: How to add table in the body of the mail through excel.

    Hi Experts,

    Any view on making the above table data dynamic for each mail.

    Regards,
    Jagdev

  10. #10
    Registered User
    Join Date
    10-15-2014
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    23

    Re: How to add table in the body of the mail through excel.

    Hi

    Any view on the above query.

    Regards,
    JD

+ 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. [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
  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. 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
  4. Macro for extracting content of outlook mail body (contains table)
    By anchuri_chaitanya in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2011, 03:29 AM
  5. If a Table is in the body of a mail.. want to extract the same in to the excel cells
    By anchuri_chaitanya in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2011, 05:38 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