Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-27-2018, 07:39 AM
janners janners is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2018
Posts: 3
janners is on a distinguished road
Default Template for Photo Directory

Has anyone used Word for a photo and personnel directory? I publish a photo directory for our Sunday school class of 190 people. I have their photo, name, address, cell phone, emails, etc., and some personal information.





I have used MS Publisher but now considering using Word and am looking for a Word template format to pull in this data from Excel. A little cumbersome using MS Pub when adding new members. I currently have two people and information on a 5-1/2 x 8-1/2 size. I print the directory once a year and also update throughout year a couple of times as a pdf and email. Looking for any help. Thank you.
Reply With Quote
  #2  
Old 12-27-2018, 10:44 AM
Charles Kenyon Charles Kenyon is online now Windows 10 Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,771
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

If you are going to make a move into Word for this, consider using mailmerge.


Mail merge with Word 2007-2019 (365) by Graham Mayor, MVP


Use an Excel file for your data including pictures.
This will make it much easier to reorganize things.
Reply With Quote
  #3  
Old 12-27-2018, 10:52 AM
Charles Kenyon Charles Kenyon is online now Windows 10 Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,771
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

This is what I found using File> New.


Note the reference to Publisher and PowerPoint templates as well.
Attached Images
File Type: png 00 deleteme 1.png (173.5 KB, 11 views)
Reply With Quote
  #4  
Old 12-27-2018, 11:12 AM
janners janners is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2018
Posts: 3
janners is on a distinguished road
Default

Thank you, Charles. I planned on using the mail merge already which is why I moving to Word from Publisher. I was also hoping to find a some kind of template that is ready to use for designing and printing my data. Unfortunately, I believe I will need to develop one myself as I am not finding one. Thanks for your help and I will keep looking for some templates.
Reply With Quote
  #5  
Old 12-27-2018, 01:31 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
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

Depending on your requirements, you may find that a label merge will do as you want, using one of the many label formats available in Word.

Also, have a read of the articles in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
http://www.msofficeforums.com/mail-m...ps-tricks.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #6  
Old 12-28-2018, 04:32 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,702
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Quote:
Originally Posted by janners View Post
Thank you, Charles. I planned on using the mail merge already which is why I moving to Word from Publisher. I was also hoping to find a some kind of template that is ready to use for designing and printing my data. Unfortunately, I believe I will need to develop one myself as I am not finding one. Thanks for your help and I will keep looking for some templates.
Maybe http://www.gmayor.com/photo_gallery_template.html might help?
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #7  
Old 12-29-2018, 03:05 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,191
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

I see that you have asked essentially the same question regarding PowerPoint, in: http://www.msofficeforums.com/powerp...directory.html
It would be better if you stuck to one application. Accordingly, please choose your preferred application and post an update in both threads as to which you want to work with.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
directory, photos

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
directory: want to a ensure all three lines in a directory entry appear on the same page. JON25T Mail Merge 3 12-22-2016 01:34 PM
Animation on photo Eric Tsang PowerPoint 1 09-28-2016 08:28 AM
Merging using directory into an existing template achuneke Mail Merge 1 03-06-2016 11:31 PM
Marking Photo JeepVoodoo OneNote 0 02-08-2016 07:37 AM
Photo Editor is Gone!!! obenix Office 2 06-07-2005 07:45 AM


All times are GMT -7. The time now is 07:56 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