Form to a letter

[glasgowlad1999]

Hi There,

I was wondering if you can help. I need to take data from a form with many sub-forms. The letter has to be in word to allow for edits. Its an appointment letter, however is has a table with 1-100 lines.

I need to be able to add the name, address, date of appointment and table with however many lines are needed for that client.

I can get the table to work by itself or the name, address and date of appointment but not both.

Has anyone done this before with access?

Thanks,
Thomas

 

[glasgowlad1999]

Does anyone have any idea how I can do this?

 

[Mihail]

My Access 2007 has the option to save a report as .rtf (rich text format).
You can open and edit this file with Word. Also you can save in .doc (or docx) format.

DoCmd.OutputTo acOutputReport, "ReportName", "RichTextFormat(*.rtf)", , True

 

[Mihail]

... and not only reports
See Access help files for OutputTo command.

 

[glasgowlad1999]

But how do I get it to show a single business name and address with an inserted table with many lines of data?

 

[Mihail]

This is another question and, maybe, is better to start a new thread.

The short answer is: by filtering your data.
The long answer depend from the setup of your DB, and is impossible for me to know at this time "how to".