I need to automate this....

[Jason Walter]

With the help from this group I was able to create a database that helps
me print letters to people who are building homes in my area.

I download a text file from the county website of all building permits
issued. I filter using a query then I have a form connected to the query
which has the name and address of the people who I want to write a
letter to.

Also on the form is a button that has some code connected to it. The
code sends the form info to a word file using bookmarks to set up the
letter the way I want it to be. Then it automatically prints the letter
and closes word.

That works great except I have to forward to the next entry on the form
and then hit the button again. I would like to have it print all of the
letters automatically. Can someone help me set that up?

Jason

 

[hansford cornett]

-----Original Message-----
With the help from this group I was able to create a database that helps
me print letters to people who are building homes in my area.

I download a text file from the county website of all building permits
issued. I filter using a query then I have a form connected to the query
which has the name and address of the people who I want to write a
letter to.

Also on the form is a button that has some code connected to it. The
code sends the form info to a word file using bookmarks to set up the
letter the way I want it to be. Then it automatically prints the letter
and closes word.

That works great except I have to forward to the next entry on the form
and then hit the button again. I would like to have it print all of the
letters automatically. Can someone help me set that up?

Jason

.
Go to the reports section and build your letter rather

than moving it to word. Place the variables from the DB
in the letter in the appropriate place. Then do a query
in access and in the properties section of the report
place the query as the data source. Your letters can now
be printed all at once from the querried information into
each letter. 100 people in querry result 100 letters
printed. Ad a command button on a form somewhere so it
will print the LETTER REPORT and your letters should be
ok..