Standard Form Letter

[Guest]

I have a standard form letter that I would like to put in a report (not sure
how) that when the user selects this report it will prompt them for the
customer name and the user will select "Acme Inc." and the standard letter
form will print out with Acme Inc.'s, address, city, province, etc.

Can someone give me some direction?

Thanks !

Ty

 

[Duane Hookom]

Use a control on a form as the criteria for your report. You can then use
text boxes with control sources like:
="Dear " & [CustName] & ":"
="It has come to our attention that " & [CustName] & " owes Duane Hookom "
& Format([AmtOwed],"currency") & " for services..."

You can also send the records to merge using Word which allows for prettier
formatting.

If you need my address to send the checks, let me know off-line.

 

[Colin Short via AccessMonster.com]

Hi - just curious about the use of "FORMAT" in your code. Can you specify a
particular section of the text within a single textbox to have italicised
letters?

Col

 

[Duane Hookom]

Format doesn't create any Rich Text Formatting. That's were you would need
to use Word or search Stephen Lebans site (www.lebans.com) for handy
utilities.