The job is to program a VB code in Excel 2007 (VB 6.5) to send an "automated" e-mail
out of a dynamic Excel-Sheet to Lotus Notes with 1 recipient, CC to myself, subject
and a formatted text copied from Excel to Lotus Notes. The e-mail solution I use is
Lotus Notes 9.0.1 Social Edition.
I attached an Excel sheet with the data to process and kindly ask you to help me
with a VB code to:
1. Open a new e-mail. Lotus Notes instance is up'n'running // no need to start it...
2. Choose Sheet("TB1") - as the document has more than just this sheet
3. Fill in: e-mail recipient ("[url removed, login to view]") // always only 1 recipient
CC ("[url removed, login to view]")
subject ("[url removed, login to view]")
4. Body: Range("[url removed, login to view]:C40")
The idea is to "copy and paste" the whole range from Excel to Lotus Notes, including
format. If the pasted text is unformatted, I'm fine too.
Thank you very much for your kind assistance.