PDA

View Full Version : Complex mail merge



N Prakash
03-30-2005, 05:36 AM
Hi! friends,

I have sorted list of data where ENO. is the key field. Each ENO. belongs to one employee. Each one is having multiple accounts and different balances are outstanding. I want to creat a mail merge document furnishing the details of each ENO the details of their account as at the end of each month. When ENO changes the new letter is to be generated in a new page. I have tried to use IF field in the braces by clicking CTRL+F9, but I am not getting the desired result.

Can any body help me please. sample data in MS Excel and sample Letter in Word format is attached.

regards,
Prakash N

mdmackillop
03-30-2005, 05:58 AM
This question has asiren before, never fully solved. Have a look here
http://www.vbaexpress.com/forum/showthread.php?t=76