+ Reply to Thread
Results 1 to 6 of 6

Table content from xlsm into Outlook - formatting issues

  1. #1
    Registered User
    Join Date
    09-02-2024
    Location
    Poland
    MS-Off Ver
    365
    Posts
    3

    Table content from xlsm into Outlook - formatting issues

    Hi

    I'm trying to generate content from xlsm to Outlook.
    I found piece of code and it works, but still have some issues to solve.
    I tried many solutions found on the internet, but probably due to not enough experience I can't manage.
    Problems I can't solved are:

    1. I would like to have transferred text in two parts: 1st (HtmlContent1) as a table without borders, 2nd (HtmlContent2) as a table with borders.
    In below code, when I put "border=1 bordercolor=black" in 2nd part only it doesn't work, so I left this parameters in 1st part and at least have borders in whole content.
    Q1: Why it doesn't work for separate parts?

    2. I did many trials to have font size as expected, but it doesn't work. I have no idea what I'm doing wrong. I tried using "font Size" tag inside table, outside table with and without additional "".
    Q2. How should I write this in the code? Having answer for this questions I would probably be able to set more parameters in a correct way.

    I think those are two challenges I have write now.
    Thank you in advance for your help.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert ByteMarks's Avatar
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,175

    Re: Table content from xlsm into Outlook - formatting issues

    Try

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

  3. #3
    Valued Forum Contributor
    Join Date
    09-18-2023
    Location
    Geogia, USA
    MS-Off Ver
    365
    Posts
    330

    Re: Table content from xlsm into Outlook - formatting issues

    There is a little tag issue here
    Please Login or Register  to view this content.

  4. #4
    Forum Expert ByteMarks's Avatar
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,175

    Re: Table content from xlsm into Outlook - formatting issues

    Don't think that affects the issue. Just adds > between the tables

  5. #5
    Valued Forum Contributor
    Join Date
    09-18-2023
    Location
    Geogia, USA
    MS-Off Ver
    365
    Posts
    330

    Re: Table content from xlsm into Outlook - formatting issues

    For sure, just a bit of housecleaning.

  6. #6
    Registered User
    Join Date
    09-02-2024
    Location
    Poland
    MS-Off Ver
    365
    Posts
    3

    Re: Table content from xlsm into Outlook - formatting issues

    Hello

    Thank you for your answers.
    I decided to go into solution with known macro written by Ron de Bruin.
    It is really great and I used it.
    It generates spreadsheet content to outlook with almost no problems.
    No, because some colors are not correctly transferred.
    I spent long time searching hundreds threads in internet but didn't found an answer.
    The case is that when I use conditional formatting with formulas (based on values in other cells) I see correct color in excel but it disappear in outlook :|
    And the most strange is that for some cases with such conditional formatting it works and for the others it doesn't.
    I understand the macro copies content as it is and when I see certain color in xls cell, I should see the same in outlook.
    Before I paste the code, maybe you have encountered similar problem and will advise me something what I can do.

    Thank you in advance for your help.

+ 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. Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 08:07 AM
  2. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  3. .XLSM Slow issues
    By jaimie1664 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2013, 10:27 AM
  4. [SOLVED] Unreadable Content When Opening .xlsm
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-22-2012, 12:37 PM
  5. 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
  6. Pivot table formatting issues
    By shellb in forum Excel General
    Replies: 0
    Last Post: 03-24-2010, 01:52 PM
  7. [SOLVED] Re: Outlook 11 > Outlook 10 Object Library Compatibility Issues
    By DW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2006, 11:35 PM

Tags for this Thread

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