Sharing info between Word, Excel and Access

[Wjones]

Any help is much appreciated...

My company resells products and services from mulitple vendors. When we
place orders with our various suppliers we are forced to key the same
information over and over again since each vendor has their own Word form.
While the forms vary from vendor to vendor, the information requested is
identical. I am searching for a way to key this information ONCE and then
"export" it into each vendor's form as needed. This would be a great time
saver and keep us from duplicating our efforts.

Here's the way I think it should work although I'm open to any and all
suggestions:
1. Identify information points needed (e.g., Name, Address, etc)
2. Create form and database in Access containing these info points.
3. Link needed info points to appropriate field in Word form and export.

Again..thanks for your help.

Wjones

 

[Crouchie1998]

Save the info in Comma Seperated Value (CSV) will allow you to import it
easily into Excel & Access, but not sure how you would benefit from importing
it into word though.

 

[Beth Melton]

If you use Office 2003 then you can take advantage of the XML
capabilities and it will do exactly what you want.

If you don't want to go this route then look into use Mail Merge in
Word and use your Access data for the data source. This process can
also be automated in Access so a user can click a button to
print/save/view the merged Word document.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Crouchie1998]

Actually, I agree the XML route would be the best way to go.

I don't agree with the mail merge idea though

 

[Beth Melton]

If you don't have Office 2003 then Office automation is really the
only option that is seamless to the user.

I've used this method in the past and it works quite well.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/