Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2018, 05:47 AM
LisaRH LisaRH is offline Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Windows 7 64bit Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Office 2010 64bit
Novice
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list
 
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 Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Windows 7 64bit Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-09-2018, 12:55 AM
LisaRH LisaRH is offline Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Windows 7 64bit Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Office 2010 64bit
Novice
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list
 
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, 11 views)
File Type: docx Mail Merge SBWA Registers 19+.docx (106.2 KB, 12 views)
Reply With Quote
  #4  
Old 08-09-2018, 03:01 PM
macropod's Avatar
macropod macropod is offline Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Windows 7 64bit Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Page breaks in a list created with mail merge Yarikh Mail Merge 5 01-16-2018 02:42 AM
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list 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
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft