Export the results of an Excel Query into Lotus Notes

[LSTAN]

Hi

I am not sure if this is the right forum to post this.

My intention is to grab the results of an Excel Query dump the results to Lotus Notes in a standard layout (as defined by me) and send out as an email.

What are the best ways to achieve this? I am just only a Notes users and have no knowledge of Notes programming. But I do have some knowledge on VBA.

Thanks in advance for any helps.

LSTAN

 

[pmonett]

How about copy/paste the relative cells into the mail ?

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[LSTAN]

Thanks, Pascal.

I have try that but the format ended as jumbled wordings in the recipients' blackberry!

I have solved the problem by saving the query in a rich text format .rtf and so far have not received any complaints from the recipients on any misalignment or jumbled text and etc...

Anyway, thanks for the reply and have a great day.