How to make a sample letter

L

lmgraca

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
 
F

fredg

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."
 
L

lmgraca

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