mail merge from excel taking to,subject and body of the msg

[aravindhan_3]

Hi,

I would appreciate very much if any of you could help me in one of the mail merge.
I have 3 columns in Excel: Email Address, Subject & one weblink for inserting with the body of the message

This is my body of the message

" Hi Please click the above link and approve"

So the mail merge should send an email to each one of the list in Column A with the Subject line in Column B, and weblink in body of the message from Column C:

I have attached a sample excel file for your reference.
Thanks for your help in advance

[macropod]

Hi aravindhan,

All you've posted so far is an Excel data source with a few rows of data plus a few more rows indicating how you want the email laid out. For the email merge you need to create your mailmerge main document for an email merge, incorporating the text and the relevant mailmerge fields.