I have this kick-ass excel macro that is basically capable of cutting down a multi-hour job into a couple of minutes. However, I'm at a loss in the end.
The last stage of the macro runs a mail merge through excel as it calls the next client, changes address, adds other personal info, prints the job, and saves it as an individual file.
My problem is that I can get the individual files to save under, say, date and client's name as an excel spreadsheet, but I'd really like to save as a pdf file. I am aware of various programs that act as a printer and basically let you save through the print dialog. The issue is, they always prompt for a name and location.
Anyone know of a pdf converter that can use an excel cell as the filename, thereby bypassing the print job prompt screen? Preferably free. =/