Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-07-2018, 05:47 AM
LisaRH LisaRH is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2018
Posts: 2
LisaRH is on a distinguished road
Default Attempting to mail merge one list into a document containing 3 pages - each page needs the same list

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
Reply With Quote
  #2  
Old 08-08-2018, 03:51 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 08-09-2018, 12:55 AM
LisaRH LisaRH is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2018
Posts: 2
LisaRH is on a distinguished road
Default Files uploaded

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
File Type: xlsx Mail Merge example.xlsx (9.8 KB, 4 views)
File Type: docx Mail Merge SBWA Registers 19+.docx (106.2 KB, 5 views)
Reply With Quote
  #4  
Old 08-09-2018, 03:01 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page breaks in a list created with mail merge Yarikh Mail Merge 5 01-16-2018 02:42 AM
Mail merge into separate list mds Mail Merge 5 04-06-2016 02:17 AM
Find and list Blank pages in Word document. ndandge Word VBA 4 11-29-2015 09:15 PM
Attempting to fix margins for numbered lists - how to modify all list items at once? ravl13 Word 1 04-28-2013 09:51 AM
Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM


All times are GMT -7. The time now is 07:27 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft