Menu:

Links:

Use these links to navigate the FAQ:

Next:
I've got a ton of data. Tests take forever!

Previous:
Extending Merge with your own VBA code .... MergeExtension

All about Merge index page

Updated
7/25/2016

Microsoft MVP Logo

I want more than one record per slide/presentation

Suppose you have a data file with Name and Title of each person but you want to create slides with two names/titles per slide rather than just one.

With a little extra work on the data file and the main PPT file you can do this. Assuming your data file looks like this:

:Name:     Title:
names     titles

you'd change it to:

:Name1:     :Title1:     :Name2:     :Title2:

And add the names and titles below as appropriate.

But what if you've already got your data file done? Copying and pasting all those names from two columns into four is tedious and error-prone.

By adding a couple of simple formulas and doing some sorting, you can make this a fairly simple process.

Download this example file (N_Records_Per_Page.xls) (right click the link and choose Save Target As, then save it to your desktop)

Follow the steps in the example file to sort and arrange your own data into as many columns as needed.

Then in your template file, you'd use :Name1:, :Name2:, :Title1:, :Title2: and so on instead of just :Name: and Merge - Merge your data and PowerPoint Presentations where you want the data to appear.

[Previous] [Home] [Next]