Merge data from Access into pdf document

[ISaunders]

I have a simple 1 page PDF document ( a flyer to mailout). I have an
existing MS Access database and I know how to code. Does anyone have
the snippet of code that will allow me to insert a Name & Address into
the PDF file via MS Access and then print the file automatically. I
would then write the code to loop through each client and print a
custom flyer for them. I do own all the Adobe programs as well.

I have tried using the Adobe Toolkit, but the documentation is
terrible.

Please don't recommend the purchase of some third party software. I
want the code please.

Please don't refer me to a previous post.

If you know the answer, just help me please.

 

[Albert D. Kallal]

Actually you don't need a purchase any software at all. and furthermore, you
don't even have to switch are printer if you use Stephens code example here:

http://www.lebans.com/reporttopdf.htm

Using the above means you don't even have to have Adobe installed are set up
on the target machine.

Keep in mind that access 2007 now does have pdf ability built in, and again
you don't even have to use Stephen's software anymore. however, for previous
versions of access Stephen's solution is ideal.

So, build your nice report With the filer layout and the detail section, you
might have to throw in a page break at the bottom the report Ron sure that
you get one record per one page, but other than that the above solution were
quite well. in other words you don't even need to write code to assert the
data to one record, because that's what a report does for you.