Exporting from Access to Word...and then sending a letter...how do I do it?

  • Thread starter Thread starter stualk
  • Start date Start date
S

stualk

Hi Folks,

I'm new to the forum but I need some help if possible. What I need t
do is export some data from Access to Word to create a letter, whic
will be sent out to people that enquire about certain things.

The table in access will merely have a persons contact details (name
address, post code etc) and 3 tick boxes. Each of the tick boxes mean
they are enquiring about a different subject, so a different lette
will be needed for each.

What I intend to do is create the three letters first with all th
relevant information (in Word), save that and then start using th
database. As I enter data and then tick a certain box, I'd like it t
automatically go to the relevant Word document and insert the address
have just entered at the top of the letter, so the letter can b
printed off.

I'm using Access 2000 and the same version of Word I think. Can anyon
help? I'd be very grateful of some advice on where to start
 
stualk said:
Hi Folks,

I'm new to the forum but I need some help if possible. What I need to
do is export some data from Access to Word to create a letter, which
will be sent out to people that enquire about certain things.

The table in access will merely have a persons contact details (name,
address, post code etc) and 3 tick boxes. Each of the tick boxes means
they are enquiring about a different subject, so a different letter
will be needed for each.

What I intend to do is create the three letters first with all the
relevant information (in Word), save that and then start using the
database. As I enter data and then tick a certain box, I'd like it to
automatically go to the relevant Word document and insert the address I
have just entered at the top of the letter, so the letter can be
printed off.

I'm using Access 2000 and the same version of Word I think. Can anyone
help? I'd be very grateful of some advice on where to start.
Click to expand...

Why don't you use the Mail Merge feature in Word? I don't have Word 2K
handy, but I just looked in Word XP and it allows you to select as the input
a Data Source, such as an Access database. Going the other way you might
have to write a lot of code that it seems MS has already done for you in
Word...
 
Back
Top