Help on Excel-Word project

[Blasting Cap]

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)
(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

 

[Jezebel]

Mailmerge will do this. Use the wizard.

 

[Blasting Cap]

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

Mailmerge will do this. Use the wizard.

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)
(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[/QUOTE]
[/QUOTE]

 

[Ed]

BC: Jezebel is by far the expert on this, but I'm just wondering from your
original posting:

Are you wanting to share this Word document among several users, with links
back to a networked Excel document, so that when any user opens the Word doc
he sees the updated info? Or is this something that will stand by itself
only on your computer, so Word and Excel only have to talk to each other on
your machine, and you will email or print a copy for anyone else?

The answers could make a big difference in the responses you get.

Ed

 

[Jezebel]

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.

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

Mailmerge will do this. Use the wizard.

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)
(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[/QUOTE]
[/QUOTE][/QUOTE]