200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have a MS word file which have multiple letters of customers intimating to them that his/her cheque is bounced. Letter is in standarad format, only customer account no and cheque numbers are different.
Problem is that physical cheques and letters print are not in same order. It takes time to find physical cheque and attached with letter.
Is there any way to sort the letters through cheque no but letter format should not change.
Sorting the letters should be done before the Word file is created. Unfortunately, you don't say how that is done. So I can only say how it should be done:-
There should be a list of customers (name, address, account No.) and check numbers. Then there should be a template containing the letter text. Using MailMerge the letters are then created, either sending them directly to the printer or to a file, and that would be the file that you mention.
In the customer list, each customer name is associated with a check number. Obviously, if you would change the sequence of the names (with the related check numbers) to match the sequence of your checks the target would be reached. But this would have to be done before merging the list with the letter text.
The attached workbook demonstrates how this could be done using Excel. It also contains precise instructions how to do it. The workbook prepares a list which you can then use in MailMerge to print letters in the sequence in which the checks are.
