Dear Friend,
Referring to the attached sheet, i need to send email for the said email addresses in particular cell. Email should pick the contents of particular row along with their headers
.
When i click the macro then from all the sheet mail addresses should receive the respective rows.
.
Subject should carry the store number and store name on each mail. Refer attached sample 1 and 2
.
Text should carry Branch Operations only if G field is filled. Refer attached sample 2
My overall outcome on the attached excel sheet required in attached outlook format as sample 1 and 2
All the email address will be available in same column.
Thanks
Referring to the attached sheet, i need to send email for the said email addresses in particular cell. Email should pick the contents of particular row along with their headers
.
When i click the macro then from all the sheet mail addresses should receive the respective rows.
.
Subject should carry the store number and store name on each mail. Refer attached sample 1 and 2
.
Text should carry Branch Operations only if G field is filled. Refer attached sample 2
My overall outcome on the attached excel sheet required in attached outlook format as sample 1 and 2
All the email address will be available in same column.
Thanks