Using Acces data in to send personalized letter

[Guest]

we have created an access database with names address etc; the input screen
works ok for these fields BUT we want to be able to input the required data
then have extra buttons that will allow the printing of a personalized letter
for the data just input/onscreen and save it at the same time, and a separate
button incase we just want ot save but not print.

Sorry if you guys think it's simple but we are very new to this.

Regards Adrian

 

[Peter Hibbs]

Hi Adrian,

There are a number of ways you could print a personalized letter. You
could create a Report each time and copy the record data to the
relevant text boxes on the report but this is limited by the
formatting options in Access reports.

You could use Microsoft Word to create a Mail Merge letter but this is
better for sending the same letter to a lot of people and would be
like using a sledgehammer to crack a nut for just one letter.

The way I do it on my databases is to use Word to create the letter
which gives you all the formatting facilities in Word and then copy
the Access record data to the letter using Automation. For example, I
would enter a code in the Word document like [FN] which would then be
replaced with the First Name field from your record.

You would need to do this with some VBA code but if you want to go
down this route, post back and I can give you some code.

I'm not sure what you mean about having a button to save the data
since entering the data into the form would automatically save the
data.

Peter Hibbs.

On Thu, 1 Mar 2007 10:10:00 -0800, Adrian Screwjack <Adrian

 

[Guest]

Thank You Peter,
I'll get back to you on the VB thingy after checking exactly what the boss
wants
Adrian

Hi Adrian,

There are a number of ways you could print a personalized letter. You
could create a Report each time and copy the record data to the
relevant text boxes on the report but this is limited by the
formatting options in Access reports.

You could use Microsoft Word to create a Mail Merge letter but this is
better for sending the same letter to a lot of people and would be
like using a sledgehammer to crack a nut for just one letter.

The way I do it on my databases is to use Word to create the letter
which gives you all the formatting facilities in Word and then copy
the Access record data to the letter using Automation. For example, I
would enter a code in the Word document like [FN] which would then be
replaced with the First Name field from your record.

You would need to do this with some VBA code but if you want to go
down this route, post back and I can give you some code.

I'm not sure what you mean about having a button to save the data
since entering the data into the form would automatically save the
data.

Peter Hibbs.

On Thu, 1 Mar 2007 10:10:00 -0800, Adrian Screwjack <Adrian

we have created an access database with names address etc; the input screen
works ok for these fields BUT we want to be able to input the required data
then have extra buttons that will allow the printing of a personalized letter
for the data just input/onscreen and save it at the same time, and a separate
button incase we just want ot save but not print.

Sorry if you guys think it's simple but we are very new to this.

Regards Adrian