Hello,

Out of my depth here. I know what I want but cannot find the exact*VBA*to solve my query. Hopefully one of you clever sparks has some code that can help.

I have a basic excel document which has the following columns:

A- Address(s)- To send email to
B- CC Address- To CC email to*
C- Subject- Subject of email
D- Body of the email (Text)
E- File path- What lotus needs to attach

The theory is Open Lotus Notes -> Create Draft -> To (lookup column a) -> CC (lookup column b) -> Subject (lookup column c) -> Body (lookup column D) -> Attach file (s) (lookup column e)

I would put this macro on a button, and copy paste on 78 rows so if necessary I could draft specific rows rather than a loop through all of them

Any ideas