mail merge using access and excel

[urvashikhanna]

hi!!
if i merge mail using access and excel, how do i merge data in one page.
if i use "next field", i have to repeat the syntax no. of times.
is there any other way to do this.

 

[Anne Troy]

If you are trying to merge multiple records, such as invoicing where there's multiple invoices for each client, try this:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg