Excel VB Code to send an automatically generated e-mail from Excel to Lotus Notes

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.

Skills: Data Entry, Data Processing, Excel, VB.NET

See more: thank you notes, m format in excel, job lotus notes, data entry in excel 2007, signature mail lotus notes, save mail lotus notes html, create html mail lotus notes, create lotus notes agent automatically forward mails lotus, lotus notes signature sample html code, send html mail lotus notes, lotus notes agent automatically forwards calendar events, agent forward mail lotus notes, html mail lotus notes, forwarding mail lotus notes agent

About the Employer:
( 2 reviews ) Reinach, Switzerland

Project ID: #9292771

Awarded to:


Hello, I can do this for you. I have experience with Lotus and I am very skilled with Excel VBA. Please contact me for more information.

$35 USD in 1 day
(13 Reviews)