Hello Guys,

I have a query and I think this is the best forum to ask.

I had seen the mail merge through VBA with Word (as an template file) and Excel (as an data source).

But the situation is I had got a task to do a mail merge through VBA but the template file is only available in either PDF or PSD (photoshop) format, we do not have any word template for it, and the data source is an excel file.

Query: I was wondering that is it possible to do an automatic mail merge (through VBA) directly with PDF or PSD file, without any word document, with data source as an excel file.

Any help or idea will be helpful for me.

Thanks,
MG