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

Without knowing anything about how the various letters differ from one another or how the data is organised to indicate which customers are which, it is difficult to recommend a course of action, but you may be able to conditionally insert the required texts that make up the difference between the customer letters and merge the whole lot as one, with the letters being created on the fly from the conditional fields.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

All you need do is use some field coding to conditionally output the content that varies according to the number of shops done. As Graham says, though, without knowing the specifics, specific advice can't be given.

That said, there are plenty of examples of field codes being used to vary text in the mailmerge threads here and in the 'Sticky' Mailmerge Tips & Tricks thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]