Letter

[Anthony]

Is it possible to create a form letter in access. I would like to pull
information from a query & plug it into a letter, Is this possible?

 

[Arvin Meyer [MVP]]

Sure, you just create a report and use labels with up to 1024 characters for
the body of the letter. If you need to insert data within the letter, or
multiple formatting (colors or bolded words) with may be easier to just use
the same query and to a merge with Word. The merge can be started from Word
and connected to the query, or you can output the data from a form to the
Word document. Code for doing that is at my website:

http://www.datastrat.com/Code/WordMerge.txt

 

[Gina Whipp]

Anthony,

Yes you can do that OR you can use Word Mail Merge and use Access as the
datasource.

 

[fredg]

Is it possible to create a form letter in access. I would like to pull
information from a query & plug it into a letter, Is this possible?

A simple form letter, sure.

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

="It has been called to our attention that your payment of " &
Format([AmtDue],"Currency") & " is now " &
DateDiff("d",[DueDate],Date()) & " days over due."

= "Please remit by " & Format(DateAdd("d",10,Date()),"mmmm d, yyyy") &
"."

= "Thank you."


A complex form letter with lot's of formatting, etc. it might be
better to just Mail Merge with Word.