Mailmerge will do this. Use the wizard.



"Blasting Cap" wrote in message
...
I have to take an excel spreadsheet that has contact info and a brief bio
and format them in a word document.

The columns in the spreadsheet are lastname, firstname, address1,
address2, city, state, zip, phone, email, bio, awards (among others)

I would like to selectively place these into the word document like this:

lastname, firstname
address1
[address2] (if non-blank)
city, state, zip
[phone] (if ok to release)
[email] (if ok to release)
bio
awards

I don't want the blank lines to show if it's not anything in it, or if
they've not authorized us to release the info.

There are other columns in the spreadsheet (as to what classification
they'd fall into) that I may not want printed in the word document.

We're wanting to update just the Excel document with the data, and have it
formatted in the word document when we open it (I am sure we will tweak
the word document formatting some), but we don't want to do any data entry
into the word document - only in excel.

Can anyone help, or perhaps guide me to a source that I can learn quickly
on?

BC