Import excel templete info into word

[Gizmo42]

Hi,
I'm fairly new to working with office and have run into a snag. I have a project where I need to have a seperate printed page with info on it for each peice of equipment in our building. The page has alot of the same things on all of them but has certain areas where it needs info specific to that peice of equipment.

I have set up an Excel template where I can enter just the equipment specific info and name and have it track changes. This way after I enter all the info for each thing it saves all the info in a seperate row for each peice of equipment in an Excel template database. So far so good.

Now for the trouble part. I have a word document with all the common info on it and would like to import the info from the template database to the proper areas. The easiest way would be to have a drop down box in the Word document that lists everything in the "equipment name" colum of the Excel database, then after picking which one it would add the info from the other cells on that row automaticly in their proper spots.

Is this even possible or am I wasting my time. I hope I was able to describe what I am trying to do properly. Sorry for being long winded.

Thanks,
Dave

 

[Kallen]

Why not just do a mail merge. Are you familiar with using mail merge? It is quite simple once it is all set up. Here is a link that will walk you through the process

http://computing.fandm.edu/training/wordx/mailmerge.html

]tutorial

 

[Gizmo42]

Thanks Kallen, that may be just what I'm looking for. I'll have to play around with it and get it all figured out.

Regards,
Dave

 

[Gizmo42]

Mail merge works great. Since the spacing on my forms depends on whats entered I still have to do a little editing to get things lined up but this is still much easier then the way I did it the last time. Thanks for the help.

Regards,
Dave