I have created and Macro which sends a mail to many in that i need to upgrade as mentioned below
Recipients Email Address STUDENT # GRADE COUNTRY
email@example.com 000123 1ST GRADE United Kingdom
firstname.lastname@example.org 000321 2D GRADE United Kingdom
email@example.com 000213 3RD GRADE United Kingdom
For each mail id it has to paste the details from Student # to Country i.e. it has to select the details from range for each mail id each item and paste on lotus notes below or above the body of message.
Pls help by advicing