can u create a report which can be used to do letters

[Phil1007]

Hi, i am just enquriing if there is a way to do a report like a mail merge letter in access.

Such as having it labeled like:-

Name
Address
City
Post Code

Dear Name,

Then have text typed in to it to start the letter.

Thank u for any responses, they will be greatly received.

 

[statsman]

Try something like this:

Textbox - Now()

Textbox - Name
Textbox - Address
Textbox - City
Textbox - Postcode

Textbox - =("Dear "&[Name]&":")

The equal sign, brackets and quotes are required for text that is in the letter that is not part of the table. For example, the first line in the body of the letter would be in a text box like this:
="We have received your letter of March 15, 2008. We regret our product failed to meet your expectations."
You will require one text box for each line of text in the letter. This makes justifcation and the like difficult. I normally jump back and forth from design view to print preview quite often to check on the layout.

If there is no data from the table in a paragraph, you can use a label rather than a text box. The label will expand in size to accept the entire paragraph.

Set the top margin of the report to accomodate business letterhead stationary if that's what you are using.

 

[GaryPanic]

check the samples under letter writers

there are a couple of options

 

[Phil1007]

Thank u, this has helped greatly