Creating a simple Pictorial Directory (like a yearbook) with EXCEL? WORD? (Entry level user)

Question

Creating a simple Pictorial Directory (like a yearbook) with EXCEL? WORD? (Entry level user)

Anonymous

Hello,

I have been asked to create a pictorial directory for a volunteer organization using Excel or WORD.

Our membership directory is in EXCEL, and changes frequently, so it needs to be fairly dynamic. The member's picture is a jpg. What we are looking for is a picture of the person with their name below their picture. Based on the pictures I've been given, the page would be a 3x4 grid (3 people per "line" and 4 "lines"/page.)

The previous directory was created in Publisher, but most of our members don't have Publisher and the previous author manually created a new document every time there was a change and distributed a pdf. TOO time consuming for me!

I looked for free templates on Microsoft and couldn't find any.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

What you are doing is generally known as creating a "photo album" or just "album".

So, you have to make sure the member name is in full as the picture file name, last name first if that is how you want to sort it.

Then use PowerPoint to create an album. It only allows for up to 4 pictures per slide. You can create an album in less than a minute! Here is a short how to video

Create Photo Album Presentation

How to create a presentation of photos quickly and easily using the Photo Album feature of PowerPoint

Right-click here and select “Save As” to download the video to your computer (2:22)

Here is the MS article on doing PPT albums:

https://support.office.com/en-us/article/Create-and-share-a-photo-album-6febdf8b-5179-4e63-90a6-0fb68df97ec6

It includes information about sharing the result as a video or emailed link.

This article is about doing subsequent updates, but I think it would be simpler to just recreate the album every time.

http://www.ellenfinkelstein.com/pptblog/add-multiple-images-existing-presentation/

Take a look at this addin for Word:

Photo Gallery Add-In for Word 2007/2010 http://gregmaxey.com/word_tip_pages/photo_gallery_add_in.html

Photo Gallery Add-In is intended make image gallery presentations in your documents as easy as typing text! The gallery images are automatically captioned with their filenames (excluding the extension) with the option of adding prefix numbering and text.

It allows up to 6 pictures across the page and allows you to automatically apply much of the photo / image editing options that are available.

I did find a bunch of photo album templates at MS for both PPT and Word. But I don't think any of them are what you are looking for

https://templates.office.com/en-us/Photo-Albums

this is a search of the template site for photo albums, it generates different results than previous link. If you want to get artsy, you may want to try some of these templates:

https://templates.office.com/en-us/Search/results?query=photo+album&search=

Off Topic

This article provides an interesting take on using Excel to create a pop-up photo album, or catalog. But this is not what you are looking for

https://www.myonlinetraininghub.com/excel-photo-album-of-our-new-zealand-trip

Answer 2

Hi,

If you're looking for a specific formatting or template to create a pictorial directory using Word or Excel, it will also take too much of your time. You may find a template to work on, however it may not include the formatting that you desire.

The answer to your query can be found in this article: Save a publication as a Word document. This will help you in converting the Publisher file into a Word document and will be easy for other members to access it.

If you have further concerns, feel free to post back.

Share via

Creating a simple Pictorial Directory (like a yearbook) with EXCEL? WORD? (Entry level user)

2 answers