Letter Generator

[ralph_noble@hotmail.com]

I have a standard letter template that I want employees to use. I want them to
fill in some forms on a page and click a button to generate the letter, but
commit what they entered in the form to an MS Access database. Does anyone have
an example of such they'd be willing to share to help me get started? Thanks.

Ralph Noble
[email]ralph_noble@hotmail.com[/email]

[cf_menace]

1. Create the form and store the data as you normally would.
2. Save the letter as an "RTF" file, not a normal Word ".doc" file.
3. Intead of the MS-Word mailmerge fields, set placeholders throughout the
letter: %firstName%.
4. Use <cffile> to read the RTF template and assign it to a variable "rtfData"
5. Run a query to get the data you stored in step 1.

6. Run multiple ReReplace() functions to repalce the placeholders with the
query data:
<cfset ReReplace(rtfData, "%firstName%", query.firstName, "ALL")>
<cfset ReReplace(rtfData, "%lastName%", query.lastName, "ALL")>
etc.

7. Use <cffile> to save the populated rtfData to a new file to the server.
OR
Use <cfcontent> to present the populated rtfData as an RTF document that
doesn't get saved to the server.

Clear as mud? :D

[Esterz]

I am trying to do as you have told, but I don't know how to save rtfData to a new .rtf file on the server. Can you help me please?

[Stressed_Simon]

Create the document in word, then do save as and choose Rich Text Fromat instead of a Word Document!

[Esterz]

Jajajaja, Stressed_Simon, I KNOW how to make and .rtf document from a .doc.
What I am asking is, when I have done the REReplace of the placeholders, I want
to save the rtfData information in a file (using cffile) with .rtf format,
because I want to send it attached in a mail.

My question is: is possible to "write", a "new file" (not overwrite the
existent template) in .rtf format (instead of the .txt format) in a dyrectory
of my server?

Thank you a lot for trying to answer me.

[Stressed_Simon]

Yes of course just save it with a .rtf extension.