Consulting

Results 1 to 5 of 5

Thread: Create New Task with Table

  1. #1

    Create New Task with Table

    Quite happy in how to create a new task in VBA but I am stuck when I wish to include a table in the body.

    What I would like is a two column by ten row table and for the code to populate each row of column one with supplied data.

    My question is how, or can, this can be achieved?

    Peter H

  2. #2
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    What is the source of the table?
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

  3. #3
    It is coming from data in an Excel sheet.

  4. #4
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    I would use the RangeToHTML procedure found here:

    http://www.rondebruin.nl/mail/folder3/mail2.htm

    But instead of creating an email, I would create a task.
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

  5. #5
    Looks perfect, thank you!

Posting Permissions

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