Log in

View Full Version : Create New Task with Table



PeterRHawkes
11-16-2011, 05:20 AM
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

JP2112
11-16-2011, 02:10 PM
What is the source of the table?

PeterRHawkes
11-16-2011, 02:11 PM
It is coming from data in an Excel sheet.

JP2112
11-17-2011, 06:25 AM
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.

PeterRHawkes
11-17-2011, 11:26 AM
Looks perfect, thank you!