William,

IMHO, the best and quickest approach would be to write a piece of code that merged an individual letter and then send that letter to PrimoPDF (or some other PDF generator -- I think FRX2ANY does this, along with some other downloads here on the UT as well) to generate the PDF document for your users' viewing with PDF Reader (you can easily automate AR from your VFP code to open a document and make the AR instance visible).

If you have trouble with the AR automation, let me know -- I have a method that does that. It's only about ten lines of code, though, so it shouldn't be a big deal.

HTH.

>Hi Evan,
>
>I'm sorry I didn't answer before, I was very busy.
>
>We're sending our letters to the third paty to print and some of the letters we were printing internally. Now we want to print all letters externally.
>
>Our initial idea was to just send them one big PDF to print. However, they don't accept PDFs, so they have to do mailmerge themselves and we just send DAT file.
>
>The problem is, that we also want to be able to view individual letters (and may be re-print individual letters).
>
>The users don't have Word, Excel and they don't have full version of Adobe (they do have PDF Reader, of course).
>
>What do you think our options should be?
>
>Thanks.
>
>
>>Hi William,
>>
>>1. Don't know if this is your question, but I use PrimoPDF (a free printer driver) to generate PDF's from *anything* that can print to a Windows queue. Small, quick install, and it does everything I've ever needed with generating PDF files from apps.
>>
>>2a. If you only have Adobe Reader installed, you can automate a search for a page ONLY if 1) you know the page number or 2) you have "named destinations" encoded inside your PDF (similar to bookmarks -- the difference is that bookmarks are inside a single PDF, where named destinations can point to other documents/PDF's/locations/et al). I have some code that automates AR8 and searches for named destinations...let me know if that will assist you.
>>
>>If you have the full version of Acrobat, it's a fully loaded Automation server, and I believe that you should be able to automate a text search fairly quickly -- check the Acrobat documentation and let us know if you can't find the way to do this.
>>
>>2b. Rather than try to navigate the big PDF, can you generate a *second* PDF with just the individual letter? That might be quicker and easier...
>>
>>HTH...
>>
>>>Hi,
>>>
>>>I have two questions.
>>>
>>>1. I use Excel & Word MailMerge to print letters. I want to be able to generate PDF instead of actually printing the letters. So, how can I create a PDF from Word after I execute MailMerge? I can install the latest Word if that's needed for generating PDF (I believe the latest Word has this capability).
>>>
>>>2. After I created a PDF with multiple (~500+) letters inside (Do you know, if there is a limitation on how many letters Word MailMerge can handle?) I want to be able to show (and print) individual letter (by Account Number) from my form using this generated big PDF. What are my options here?
>>>
>>>Thanks.