How to mail merge in excel from excel and save all files individually in excel format ?

[shaikhstonevilla]

Hi,

I have two excel files. (Say A & B).

"A" excel file contains data of 100 Names, Addresses, Zip Codes Etc.

"B" excel file contains template letter format.

What i want to do is export data from "A" excel file to "B" excel file and save all 100 files individually.

Is there any excel function or VBA code for that ? It will help me a lot.

Thanks,
Tim.

 

[Andrew Poulsom]

Can't you use Word?

Mail merge using an Excel spreadsheet - Word - Office.com

 

[Andrew Poulsom]

Here's another possibility:

Spreadsheet Page Excel Tips: Mail Merge - Without Word