Hi all.


I've set up a mail merge template to complete register information using the data from one excel worksheet.


I need:

page 1 to list the learners from the worksheet
Page 2 is a register and needs to list the same learners plus other data i've prepared such as dates of sessions
Page 3 again needs to list the learners and information relevant to a different qual.


The problem i'm having is that when i run mail merge it inputs the names into page 1 and nothing else. If i delete the name fields from page 1, it will then input all information needed on page 2 but nothing on page 3.


So - each page appears to be set up correctly to work if it was a one page document but together as a 3 page document - it won't work.




I know it's probably straight forward and i'm doing something wrong but i can not figure it out.


Hope someone can help,
Lisa

Without actually seeing the mailmerge main document and some sample data, it can be difficult for anyone to diagnose the issue and advise. Can you attach the mailmerge main document to a post with some representative data (delete/obfuscate anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

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

Hi,


Thanks for your reply.


I've attached an example mail merge document with the 3 page word template for the registers and data.


I could separate the 3 pages and run the mail merge on each individual document but was hoping I could run it once and complete all the data in one document.


Hoping you can help,
Thank you
Lisa

Attached Files

	Mail Merge example.xlsx (9.8 KB, 13 views)
	Mail Merge SBWA Registers 19+.docx (106.2 KB, 14 views)

Your requirements really aren't conducive to a mailmerge; it's the kind of thing one really needs to use VBA for. I could help with that but, before doing so, I'd need to know whether you want to run the process from Word or Excel.

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