Menu:

Links:

Use these links to navigate the FAQ:

Next:
Can I arrange my data in columns instead of in rows?

Previous:
How to merge Hyperlinks

All about Merge index page

Updated
7/25/2016

Microsoft MVP Logo

Do I have to accept Merge's names for merged files?

Normally when you do a Presentations merge (create multiple presentations from a single template and data file) Merge names the presentations 1.PPT, 2.PPT and so on.

That saves you the trouble of naming each one as it's created.

But that makes it hard to work out whose data is in which presentation. And besides, you may have your own ideas on how the files should be named.

No problem, Merge's ready to work with you.

Simply add a @filename field to your data file (for example, in Excel, add a new column with @filename in the top row; you'll actually need to use '@filename -- prefix it with an apostrophe -- so Excel treats it as text rather than as a formula).

In the @filename field of each record, type the name you want Merge to use for the PPT file it creates from that record's data. Type just the file name, not the path ... Merge will ask for the output path when you merge your data and create the files.

So the first column of your data file might look like this:

@filename
this
that
the
other

Merge will create PowerPoint files named this.ppt, that.ppt, etc.

If you wish, you can force the file extension in case you want PPS (Show) files, for example:

@filename
this.pps
that.pps
the.pps
other.pps

If you use PowerPoint 2007, you can also specify .PPTX and .PPSX extensions for the resulting files.

[Previous] [Home] [Next]