Can I generate my mail merge documents directly from Microsoft Acc

[Scott]

I have built a simple database at my office to collect data for the sole
purpose of generating form letters that I mail merge in microsoft word. I am
trying to streamline the entire process by using the database to do
everything including generating these letters. This would save me time by
not having to open the form letters and point it back to the database. Does
anyone have any other suggestions if this can't be done? I thought about
somehow creating the letters as reports in the database, but not sure how
difficult that would be.

Thanks!

 

[Joan Wild]

I have built a simple database at my office to collect data for the sole
purpose of generating form letters that I mail merge in microsoft word. I
am
trying to streamline the entire process by using the database to do
everything including generating these letters. This would save me time by
not having to open the form letters and point it back to the database.
Does
anyone have any other suggestions if this can't be done? I thought about
somehow creating the letters as reports in the database, but not sure how
difficult that would be.

Have a look at Super Easy Word Merge at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Scott]

Thanks for the link Joan. It works great. The only thing I am not able to
do (or have not figured out how to do) is to be able to merge a certian group
of documents. Because this code does not attach the merge to the database
(which is nice for all other reasons) I am not able to sort and merge records
based on data in certian fields. Is there a way around this with this
gentleman's code? For instance, if I have a date field and I want to click
the button and merge all records that were edited on 5/15/2005, is this
possible?

Once again, thank you for the link....it has been a great help.

 

[Scott]

Also, what does the author mean by "splitting" the database to share it over
a network?

 

[Joan Wild]

Thanks for the link Joan. It works great. The only thing I am not able
to
do (or have not figured out how to do) is to be able to merge a certian
group
of documents. Because this code does not attach the merge to the database
(which is nice for all other reasons) I am not able to sort and merge
records
based on data in certian fields. Is there a way around this with this
gentleman's code? For instance, if I have a date field and I want to
click
the button and merge all records that were edited on 5/15/2005, is this
possible?

Perhaps Albert will jump in here, as I haven't scrutinized his solution. I
believe he uses a form to do the merge. You should be able to set your
form's recordsource to a query which prompts you for the date.

 

[Joan Wild]

Also, what does the author mean by "splitting" the database to share it
over
a network?

It is always a good idea to split a database that is going to be shared by
multiple users.

The backend (containing just the tables/relationships), is put on the
server. The frontend (contains all other objects), is put on each user's
workstation. The frontend contains linked tables (linked to the backend).
More reading...
http://www.granite.ab.ca/access/splitapp/index.htm
http://allenbrowne.com.au/ser-01.html

 

[Scott]

thanks Joan...I have been in contact with him and I am hoping he can help me
figure this out before I drive him too crazy. Thanks to all of you.