Sending Word Doc attachment using Lotus Notes 8.5

Hi!

I hope someone can help me...and make it easily understood. I'm such a newbie.

I am using Excel 2010 32bit & Lotus Notes 8.5.

I have an Excel 2010 list with columns named:

Institution Name (A2:A158)
Code (B2:B158)
email address (C2:C158)
location the word attachment is located (D2:D158)

I have a Lotus Notes stationary letter already set up in Lotus, all it needs is the appropriate merge info from the Excel list inserted.

I want to be able to do the following automatically:

- Open the aforementioned stationary.
- Enter the email address from C2.
- Insert the code from B2 & the institution name from A2 into the body of the email in their appropriate spots.
- Attach the corresponding Word document for that email.
- Automatically send with a copy going into the sent folder.
- Have Lotus open the same stationary again and do the steps above only this time, it would be the next line of information and the corresponding Word document.

Does this sound possible??

Any help provided would be much appreciated!

Thank you so much!
Syn

This sounds more like a Lotus Notes question than an Excel question.

Hi!

Thanks for your reply.

Actually, I understand there is some sort of VBA code(s) that I can use, but I have no idea how to write one.

No problem. I'm not too familiar with Lotus Notes, but VBA expands far beyond Excel, and perhaps Lotus Notes uses a similar language (VB)? You can potentially control any object (e.g. Lotus Notes) from Excel, but you would need a reference library and I doubt it exists - especially since it's written by IBM.