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