Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-04-2016, 01:31 PM
oliboi oliboi is offline Windows 8 Office 2013
Novice
 
Join Date: Feb 2016
Location: Canada
Posts: 12
oliboi is on a distinguished road
Default Merging Excel content to form

I have an Excel document which looks like this (please click on the image to see the full image):





I have many records.
I want to merge these records onto a word document so that it looks like this (please click on the image to see the full image:



How can I do this? I need to put similar information for several people on the word document (thus, about 6 records per page)

Can I also merge the font?
Reply With Quote
  #2  
Old 11-04-2016, 03:34 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,650
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 behold
Default

This is a fairly basic mailmerge, though you should consider changing some of the workbook's headings - timespans really aren't appropriate for that (e.g. you don't want to have to change the mailmerge main document just because someone decides a different timespan is needed).

A mailmerge cannot retrieve the font data - you have to do all the formatting in Word.

PS: Rather than linking to external websites, it is preferable for the content to be attached here - which you can do via the paperclip symbol on the 'Go Advanced' posting screen.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 11-07-2016, 07:02 AM
oliboi oliboi is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2016
Location: Canada
Posts: 12
oliboi is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
This is a fairly basic mailmerge, though you should consider changing some of the workbook's headings - timespans really aren't appropriate for that (e.g. you don't want to have to change the mailmerge main document just because someone decides a different timespan is needed).
.
Thanks for the reply. However I do not understand what you mean by timespan. Do you mean the workshops times which are indicated on the Excel sheet?
Reply With Quote
  #4  
Old 11-07-2016, 12:41 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,650
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 behold
Default

Quote:
Originally Posted by oliboi View Post
I do not understand what you mean by timespan. Do you mean the workshops times which are indicated on the Excel sheet?
Precisely. You have a column headed with 12:45-1:20pm. You also have multiple columns with the same name for the header row.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 11-07-2016, 03:46 PM
oliboi oliboi is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2016
Location: Canada
Posts: 12
oliboi is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Precisely. You have a column headed with 12:45-1:20pm. You also have multiple columns with the same name for the header row.
Do you suggest that I just remove the time headings? Technically, I do not need the name of the headings in Word, just the information on each column

Also, how can I make it so that I can put several labels on one page?
Reply With Quote
  #6  
Old 11-07-2016, 04:35 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,650
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 behold
Default

No, you should keep the headings, but make them more meaningful (and accurate). Without them, your mailmerge setup & maintenance becomes much more difficult. As for outputting more than one record per page, use a label merge or a directory merge.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 11-07-2016, 05:16 PM
oliboi oliboi is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2016
Location: Canada
Posts: 12
oliboi is on a distinguished road
Default

I managed to insert 6 records onto one page. However, when I click on next record (technically going on to the next sheet), it shows me 5 of the same names as the previous page with only one new name.
Reply With Quote
  #8  
Old 11-07-2016, 05:44 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,650
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 behold
Default

All you are doing is previewing the merge, you need to finish it - using Finish & Merge...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
merging
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form with content controls - expands but at the bottom of the form louiseword Word 3 05-27-2016 12:47 AM
Excel found unreadable content in file.xls. Do you want to recover the content of this workbook? Sanfran Excel 2 10-21-2014 12:09 AM
Updating an old form with Content Controls Something Anon Word 4 03-26-2014 03:53 PM
Content Controls Form Programming beachdog Word 4 09-20-2011 10:26 AM
Form Content boxes help mac173173 Word 1 06-24-2011 03:49 AM


All times are GMT -7. The time now is 05:15 PM.


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