How to Create Letter like Reports - Help Me Please!

[Eve]

I would like to create a report that looks like a letter inserting multiple fields from a query. The problem is the body of the letter will not fit into a textbox. Can I create a memo field in a report without modifying query or tables?

 

[Pat Hartman]

Use several text boxes if one is not big enough.

 

[Maryanne]

You can use text boxes but the formatting is not the easy to control. I use "Publish It with MS Word" under Tools/Office Links... Then you just set up a mail merge letter.

 

[TommyIndigo]

I'm not sure if I have a full understanding of the problem, but you can set the "can grow" property to YES in a text box. This would automatically resize the text box to become a large as it's content requires.

 

[Pat Hartman]

There is an article available from the support site that explains how to do this.
Q98798 - ACC: Creating Reports to Mail Merge Microsoft Access Data.