Hi All,

I want to create a new email in Lotus, fill in the subject, send to/cc and body text fields without sending until user presses button within Lotus.


1) First problem I have with body of the email. It should contain a table copied directly from Excel.

Here's my code:
Please Login or Register  to view this content.
In line with "data.GetText", macro is copying the whole table, but only as a plain text (without borders, format etc.). Is there any way to copy table from Excel into Lotus email body, while maintaining formatting?


2) The second problem is the body text is inserting directly after the Lotus Notes signature. I know, why not disable the signature in Lotus Notes. The problem is, this is being sent from a group box and I cannot disable it for all users. So my thought is I need some code that will either empty the body text (delete the signature) and then I can create the signature for the email directly in VBA. Or can I move the bodytext above the signature from within VBA?

Thanks in advance