Using Merge Field in file name?

**The Boosh!** · 04-15-2011, 07:08 AM

Hi All,

I'm trying to put together a simple bit of code that cycles through my mail merge, and prints to PDF using a merge field value as a file name. The code i've got at the minute is as follows:

Please Login or Register  to view this content.

I'm normally fairly competant in excel with this sort of thing but word is a new ball game for me so any help would be much appreciated

**Domski** · 04-15-2011, 07:22 AM

Hi,

Not sure how much help I'll be as like you Word isn't my thing but I'll try.

What software are you using to create the pdf?

Dom

PS I may get told off for promoting a competitor but I know MacroPod (Word MVP) hangs around at Mr Excel sometimes and has helped me in the past.

**The Boosh!** · 04-15-2011, 07:46 AM

Hi Dom,

I'm using an adobe driver I think? It's set up as a printer, and you click print to pdf!

**Domski** · 04-15-2011, 08:02 AM

You need to have Adobe Acrobat Professional if you want to control it with vba as far as specifying file names etc

There's a link to some code I wrote here along with one that uses some alternative free pdf software:

http://www.excelforum.com/excel-prog...be-writer.html

It's all Excel oriented but theory should be the same if working with Word.

Of course if you have access to Office 2007/2010 then pdf printing is built in.

Dom

**The Boosh!** · 04-15-2011, 08:18 AM

Thanks for that dom.

The pdf driver definitely works as i've used it with excel vba. The syntax for word doesn't appear to be the same though

**Domski** · 04-15-2011, 08:28 AM

The driver itself is basically a printer driver so you can control it via vba as far as printing like your code showed but to do anything else you would need the pro version which allows you to set references to the distiller and control the file name etc. You might want to check out Planet PDF as well.

Dom