Populating Word/Excel from Access

[DannyJ]

Dear All,

I was wondering if you could help me/ I would like to create a Word or
Excel table with name, address, email etc. this information is already held
in an access database and I do not wish to enter it again for each
individual. Is there a way of linking the information to the table such
that I enter the individuals name and the other fields self populate? Would
this be better as an Access report?

Your thoughts much appreciaed.

Thank you,

Danny

 

[DL]

Use an access report. I'm assuming you just want a record of these items.
Or you could export the data and import to outlook contacts (export in a
format that OL understands)

 

[Joseph Meehan]

Dear All,

I was wondering if you could help me/ I would like to create a Word
or Excel table with name, address, email etc. this information is
already held in an access database and I do not wish to enter it
again for each individual. Is there a way of linking the information
to the table such that I enter the individuals name and the other
fields self populate? Would this be better as an Access report?

Your thoughts much appreciaed.

Thank you,

Danny

Sure. Just use the menu commands to the tools - Office commands to
merge-publish in word or analyze in Excel.

 

[Albert D. Kallal]

I have a working sample that does what you ask here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

You can try the sample (it is ready to go with 2 records!!).

If you like it..then I have step by step instructions on how to use this
example your exiting applications.

 

[DannyJ]

Thanks guys!

Much appreciated.

Danny

Sure. Just use the menu commands to the tools - Office commands to
merge-publish in word or analyze in Excel.

 

[DannyJ]

Very nice, Thanks