Mailmerge and PDF

[CassioAcc]

I'm looking for a solution that will allow me to use the mail merge function in word to email documents out, however instead of mailing out the word documents, I want them to be converted to PDF files.

Probably a macro but would like to avoid this.

Any ideas?

[Karl89]

If you've got the latest Office just save the document as a .pdf and then email it manually.

[davidshaw89]

or if you don't have the most up-to-date office suite;

use a pdf printer (such as primo pdf) to convert to pdf instead of printing, and then insert into the e-mails manually.

[CassioAcc]

Thanks, I do have the latest office but as I am mailing to a largish list I would prefer not to have manual intervention.

[JElder]

There is tis:


http://www.pdfmachine.com/

Never tried it, but should do.

I have created an auto report distribution system that ran in Access97 - generated a custom report, exported, converted to pdf, generated email, added attachment, entered email text, and sent.

Have to know Access VBA to get it working, though.

[Subbynet]

Hi,
If you have Adobe Acrobat, its mail out functions integrated into Microsoft Word (2007 - should be the same on others) allow you to save to separate PDF files, and then (if required) send to a list of recipients (PDF Attached), which you can choose from a table in the database you’ve already used to generate the mail merge data.

http://screencast.com/t/VXHiXg8A

ps. You need to open Outlook afterwards to actually send the e-mails.

[CassioAcc]

stupid question time - is adobe acrobat the same as adobe reader?

[justintime]

stupid question time - is adobe acrobat the same as adobe reader?

No its not, reader will only read a pdf but with acrobat you can make pdf files as well.

[Made4Print]

Hi,

How much customisation is required for the PDF's and is this a one off email?

For instance/some solutions:

If this is a newletter, just customise the email with a link to the same PDF from within each email?

Is it possible to just send the email with no attachment?

If the PDF is an invoice or some other templated document that will used on-going, you may want to have this built as a custom software development project (there are various ways to do this, please PM me for more details)

If you know how to program macros/vba and its possible, it may be possible to merge a word doc through outlook?

HTH

Mark Redman

[MyAccountantOnline]

I'm looking for a solution that will allow me to use the mail merge function in word to email documents out, however instead of mailing out the word documents, I want them to be converted to PDF files.

Probably a macro but would like to avoid this.

Any ideas?

Hi Aaron

I spent a very long time looking at this probably for similar use as you! In the end I decided it was too long-winded and hard work and am looking at this -
http://www.mailchimp.com/

Might be worth a look.