Can I export data from Access to a created form in MS Word

G

Guest

I want to setup a form in MS Word with certain fields that can have data from
a MS Access database imported into. For example, the MS Word document would
have a name field, can I type in the particular person's name and then
through some process (macro/embedded or linked object?) have all the other
fields in the MS Word document updated with this person's data?
 
J

Joseph Meehan

questions said:
I want to setup a form in MS Word with certain fields that can have
data from a MS Access database imported into. For example, the MS
Word document would have a name field, can I type in the particular
person's name and then through some process (macro/embedded or linked
object?) have all the other fields in the MS Word document updated
with this person's data?

In Word with a blank document or the one you want to use as a base open,
select View-tool bars-Mail Merge if that toolbar is not open. Then select
the Icon to select a data source and use that to find your Access Database,
select it and then you will be able to add field from your table or query to
your Word document.
 
G

Guest

Not exactly working in Word directly but one straight forward approach would
be to creat a Report that has the Word doc layout that you want......

One would then select the Person from the combo box - or start typing in and
it will auto-complete......once the person is selected you would generate the
report based on that record data...

not sure exactly where you are going with this but the Report can be
printed, viewed or sent out as a Word doc from there....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top