How to make a sample letter

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

Guest

Hi there,

I'm working on a database, specifically on a special report that I want to
be a sample letter. This letter will be sent to differenbt people and some
of the fields will change in order to meet each of its adressees details. My
question is, how do I make a formatted text and introduce in it fields?

Thank you for your help

Luís
 
Hi there,

I'm working on a database, specifically on a special report that I want to
be a sample letter. This letter will be sent to differenbt people and some
of the fields will change in order to meet each of its adressees details. My
question is, how do I make a formatted text and introduce in it fields?

Thank you for your help

Luís
Click to expand...

You could make your letter using unbound controls and concatenating
text and fields.
Perhaps something like this:

="Dear " & [FirstName] & " " & [LastName] & ","

="Your loan balance of " & format([Principal],"$ #,##0.00") & " is due
on " & format([DueDate],"dddd, mmmm,d,yyyy") & "."

= "A late charge of " & [LateFee] & " will be added if the payment is
not received on time." & chr(13) & chr(10) & "We wish to thank you for
your business."
 
Fred,

Thank you so much. You really helped me.

All the best.

Luís

fredg said:
Hi there,

I'm working on a database, specifically on a special report that I want to
be a sample letter. This letter will be sent to differenbt people and some
of the fields will change in order to meet each of its adressees details. My
question is, how do I make a formatted text and introduce in it fields?

Thank you for your help

Luís
Click to expand...

You could make your letter using unbound controls and concatenating
text and fields.
Perhaps something like this:

="Dear " & [FirstName] & " " & [LastName] & ","

="Your loan balance of " & format([Principal],"$ #,##0.00") & " is due
on " & format([DueDate],"dddd, mmmm,d,yyyy") & "."

= "A late charge of " & [LateFee] & " will be added if the payment is
not received on time." & chr(13) & chr(10) & "We wish to thank you for
your business."
Click to expand...
 
Back
Top