Follow the instructions for mailmerge labels, or read the help tutorial on
using MailMerge to set up a catalog from a database.

Basically, you insert the fields for the first item, then use a NEXT field,
and go on to the next item, and so on.





"Blasting Cap" wrote in message
...
I've tried using this, but it will only put one set of info per page. How
do you get it to put several of them on a single page?


BC



Jezebel wrote:
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