Sorting of ms word file

0

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.

Answer
Discuss

Answers

0

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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login