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: 16,647
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: 16,647
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
... 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: 16,647
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: 16,647
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

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 08:53 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