Inserting fields from Excel

[Linda RQ]

Hi Everyone,

Using Office 2003 which is new to me. I have an excel sheet with Name,
Number 1, Number 2, Faciliy as column headers. I would like to insert these
fields on word documents. I have 300 records and will have 300 word
documents with these fields on them. All fields will go on one document
which is set up as a table with the same field names.

I have tried to play around using mail merge but it's not working out very
well. I think I did something similar using mail merge a few years ago but
I was using Office 2000 and the mail merge seems to have changed a bit.

Thanks,
Linda

 

[Doug Robbins - Word MVP]

I suggest that from the View menu, you select Toolbars and then check the
Mail Merge item to display the Mail Merge toolbar. That toolbar contains
buttons that will allow you to select the main document type, attach the
data source and insert the merge fields in the configuration that you want
and then to execute the merge to the required destination (new document,
printer, email).

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Linda RQ]

Thanks! That sure is easier than that wizard in the tools menu. I was able
to get it close to what I want and I am sure I can probably play around to
get it perfect. I may be back in a few days.

Linda

 

[Suzanne S. Barnhill]

For more on this, see
http://sbarnhill.mvps.org/WordFAQs/ExpressMailMerges.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.