Please anyone suggest me with following scenario.
I have a template document (template.doc) with mail merge (Merge field) option. I have to convert this document (template.doc) to excel file along with the mail merge option. How to do this? Also the converted template (.xls) should look like the same as in document template (.doc) in font size, color, header, footer, image and merge field. How to achive this. Please suggest me with sample or some URL where i can find some good solution to do this.
Note: Here i am just creating the Merge field (place holder) alone in the excel template, no need for merging the data. It's done is another phase, so no need to workout with that here.
Thanks in advance.