Software

What about using an access database with a table containing the topics and a yes/no field. You then can create a query selecting those items where the checkbox = 0 and make a report on it.
To sent this by e-mail you could use a snapshot or if you are interested I know a hyperlink to Primopdf (freeware) to create pdf files to sent as object.

p.verhagen14@chello.nl

Here is some more information.
If the document were filled out as shown below, only the text line starting with a number 1 (this is a checkbox form field in MS Word) would print and if the line starts with a 0 the line would not print and the other text would close up so there wouldn?t be any gaps in the letter. There is a text box after each topic, if the text box is filled in then it should print, if the text box is left blank, the space should fill in with the text below.
Sample letter to licensee:

The following items regarding your application are outstanding:

1 Application Fee Paid
0 [text form field is here]

0 Application Completely Filled In
0 [text form field is here]

1 2 x 2? Passport Quality Photo
1 Please send photo [text form field is here. There may or may not be text in the text form field which is entered by a clerk]

1 Proof of Graduation
1 Proof of Graduation - A copy of your acupuncture school diploma. [text form field is here]

0 Dean?s Letter
0 Dean?s Letter - The Dean or administrator of your acupuncture program must send verification.
0 [text form field is here]

0 Accredited School
0 [text form field is here]

1 5 years' practice/500 patients
0 [text form field is here]


The sample letter would look like this when printed out to send to the licensee:

November 4, 2004

<<Name>> {mailmerge field}
<<address>> {mailmerge field}

Dear <<Mr.,Ms.>> {mailmerge field}

The Oregon Board of Medical Examiners has received your application for licensure as an acupuncturist in the State of Oregon. The following items regarding your application are outstanding:

1 Application Fee Paid

1 2 x 2? Passport Quality Photo
1 Please send photo

1 Proof of Graduation
1 Proof of Graduation - A copy of your acupuncture school diploma.

1 5 years' practice/500 patients

Use an IF field and INCLUDETEXT.
If your merge data has a certain value insert on piece of text, otherwise alternate text or nothing.
A document with bookmarked text will supply the information.

The programmer came back from vacation today and told me to stop working on this project. Isn't life fun? :)

Thanks for all your help.

This question was closed by the author