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

shaikhstonevilla

New Member
Joined
Dec 5, 2012
Messages
22
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.
 

Forum statistics

Threads
1,082,629
Messages
5,366,645
Members
400,908
Latest member
currong

Some videos you may like

This Week's Hot Topics

Top