Hi all,



I have data in excel file (Attached). I want to mail merge 2 records in one page as shown in word file attached.

Column A in excel file represents page no. and Sl.No (1-4) represents Associate Name should be printed serially as shown in word file.

Is it possible through mail merge. If possible please help me.

Attached Files

	Trail Data.xlsx (11.6 KB, 22 views)
	L_sheet.docx (14.0 KB, 19 views)

Simply insert the required mergefield in each cell, plus «Next Record» fields in all 'Sl. No' cells but the first.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

If this is not possible with mail merge.. please suggest any other way to get printout as shown in word format.

I have already told you how to do it with mailmerge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi. I tried the <<Next Record>> in my mail merge document but the addressee (merge field) on the second record of the first page is repeated on the first record of the second page.

That's not what I see. See attached mailmerge main document & output document.

Attached Files

	Output.docx (32.4 KB, 29 views)
	L_sheet.docx (18.5 KB, 20 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul, thank you. I missed the very important part of your first reply to the OP, "but the first."

Hi,

I have seen Directory in Mail Merge option, can we get exact report as per requirement.

Please try in that toggle coding, need to be filled in table and other fields should be placed with insert field option.

Thanks and Regards,
Prasad Emany