Consulting

Results 1 to 3 of 3

Thread: Convert Excel range into HTML table

  1. #1

    Convert Excel range into HTML table

    Hi all,

    I wanted to set a macro to automatically retrieve the range i need, and then convert it into a HTML table like the below picture so that i could insert into outlook email

    Requirement
    (a) The first row of the HTML table should be A to Z
    (b) The first column is numbering
    (c) The first two columns in 1 colour (CODE: #E5E8E8) and the rest in another colour (code: red)
    (d) To skip columns "Sex" and "Hobby"
    (e) any text format

    I have tried to make reference to the guide in the below link, but it provides me only a solution to convert my information into a "fixed format" (i.e. font: calibri ; text size: 12....)
    https://excelsirji.com/vba-code-to-c...to-html-table/

    I am a newbie to VBA and need a helping hand. Would my requirement(s) result in very complicated code? Really need help formatting the HTML table.

    Million thanks.

  2. #2

  3. #3
    VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,709
    Location
    Save As >> Single Page Web file
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •