I am using MS Word 2010. I follow the instructions in http://support.microsoft.com/en-us/kb/211303/en-us, unfortunately, I can't make it work. Attached please find the data file. Please help.

Attached Files

	testdata.xls (22.5 KB, 8 views)
	mailmerge.docx (15.6 KB, 9 views)

You have fields within fields e.g. { MERGEFIELD { MERGEFIELD City }} whereas it should simply be { MERGEFIELD City }. But you may find the process easier to follow if you look at Paul Edstein's tutorial which you can download from the downloads page of my web site.

And if you want separate documents for each city, you should find http://www.gmayor.com/ManyToOne.htm altogether simpler to set up, though this is not a true mail merge process.

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

Dear Graham

Thanks for your kind help. I am now able to produce a single document with page breaks separating at the "Key" changes. However, if I change the document type to e-mail messages, the grouping doesn't work. Instead, it geneate each records in excel as a separated email like this

email 1
123456 Vicky 100.00

email 2
A98765 May 50

email 3
A98765 May 500

But, I would like to send the email to recepients like below
email 1
123456 Vicky 100.00

email 2
A98765 May 50
A98765 May 500


Please help

If you are using the original process, you will have to merge to a new document then split it and mail the resulting documents.

http://www.gmayor.com/ManyToOne.htm will do it all in one process, but you will have to create a new merge document to work with it. See the example file which is more or less what you are doing.

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