print different letter for different people
Hi in Excel 2013 i have a list of customers in one column and how many shops they have done with us in another row.
i have letters typed in word 2013 i send to the 1st time customers a different letter i send to the 2nd time customers and also another letter to customers that have done 50, 100,150,200,250.....etc shops, that i merge the names into from the excel document
at the minute i open the 1st letter go to edit recipient list and select all the 1st customers, print that letter and then open 2nd do the same also do the same for the 50th 100th...etc shops too
I would like to be able to open one document start the mail merge and it prints off all the different letters i need in one go. or even be able to automatically print the letter off in excel somehow if it makes things easier?
Any suggestions are much appreciated and hopefully i can save a bit time so i can use it more efficiently
|