Standard Form Letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
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.
 
Back
Top