Hi,
I need some help in the following situation. Please do the needful.
I have a macro which sends mail to users with an attachments & fixed email body. I need some changes in email body configeration. File is enclosed for ready reference.
In email body i want to refer a cell content for each mail individually.
For example in the enclosed file email body should refer the data in cell (K1:K5).
Cell K1, K2, K4 & K5 cell data in email must be constant & cell K3 should be changed in each email body.
In the email body for 3rd sentence it should refer the column G data individually & send email individually. It should change for all the emails as per G column data.
Pls help me on this.
Regsrds
Bookmarks