By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Instructions on how to Create a Word document that Links To Access DB

P: n/a
di
I have a Access Database, and I would like to create a word document
that
(preferable would filter)links to ACCESS table or query. I would like
to print the word document on the filtered record that I have selected
in Access.
for example if I have customer number (201) that I would like to merge
over to a Word document. The word document is a template that I would
like to use regularly.

Thanks so Much for anyone that can WALK me thru the process. Step by
step,

I have tried the Hyperlink option - but it doesn't see to be working
right.

Isn't there an easy way to create such a thing. In the past I
created all my templates in the FORM view and have printed from the
Forms. But
Some letters are easier generated in MS Word.

Thanks again!
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Try the following sample download word merge of mine:

http://www.attcanada.net/~kallal.msn.../msaccess.html

Give that working sample a try..and then to use it in your application..just
read the additional instructions on my web site...

My example is designed to be used with YOUR application...
Good Luck.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl******************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #2

P: n/a
ok, i've been doing this very frequently in my job ...
perhaps u might find this useful

Step 1 : create your query with all the information that u'll need on that
merged letter
Step 2 : run the query and ensure the result is as u wanted.
Step 3 : while still looking at your query, select 'Tools' --> 'Office
Links' --> 'Merge it with MS Words'
Step 4 : MS Word will be activiated and prompts you to select a document to
merge to. Ignore this and opts for a new word document
Step 5 : you'll then be presented with a black document, ready for you to
edit.
Step 6 : edit your document, at the Toolbars portion of ms word (at the
top), right click and select the 'Mail Merge' toolbars.
Step 7 : you may try to play around with the mail merge toolbar, selecting
whatever u need to.

Hope the above helps.

______________________________________
Lawrence Lee
"di" <di******@charter.net> wrote in message
news:9b**************************@posting.google.c om...
I have a Access Database, and I would like to create a word document
that
(preferable would filter)links to ACCESS table or query. I would like
to print the word document on the filtered record that I have selected
in Access.
for example if I have customer number (201) that I would like to merge
over to a Word document. The word document is a template that I would
like to use regularly.

Thanks so Much for anyone that can WALK me thru the process. Step by
step,

I have tried the Hyperlink option - but it doesn't see to be working
right.

Isn't there an easy way to create such a thing. In the past I
created all my templates in the FORM view and have printed from the
Forms. But
Some letters are easier generated in MS Word.

Thanks again!
Nov 12 '05 #3

P: n/a
di
Thanks for both versions - I tried both of them and I know I will have
a need for both versions in the future.
Thanks you very Much!!


"Lawrence" <ga******@singnet.com.sg> wrote in message news:<c6**********@mawar.singnet.com.sg>...
ok, i've been doing this very frequently in my job ...
perhaps u might find this useful

Step 1 : create your query with all the information that u'll need on that
merged letter
Step 2 : run the query and ensure the result is as u wanted.
Step 3 : while still looking at your query, select 'Tools' --> 'Office
Links' --> 'Merge it with MS Words'
Step 4 : MS Word will be activiated and prompts you to select a document to
merge to. Ignore this and opts for a new word document
Step 5 : you'll then be presented with a black document, ready for you to
edit.
Step 6 : edit your document, at the Toolbars portion of ms word (at the
top), right click and select the 'Mail Merge' toolbars.
Step 7 : you may try to play around with the mail merge toolbar, selecting
whatever u need to.

Hope the above helps.

______________________________________
Lawrence Lee
"di" <di******@charter.net> wrote in message
news:9b**************************@posting.google.c om...
I have a Access Database, and I would like to create a word document
that
(preferable would filter)links to ACCESS table or query. I would like
to print the word document on the filtered record that I have selected
in Access.
for example if I have customer number (201) that I would like to merge
over to a Word document. The word document is a template that I would
like to use regularly.

Thanks so Much for anyone that can WALK me thru the process. Step by
step,

I have tried the Hyperlink option - but it doesn't see to be working
right.

Isn't there an easy way to create such a thing. In the past I
created all my templates in the FORM view and have printed from the
Forms. But
Some letters are easier generated in MS Word.

Thanks again!

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.