auto merge field

[Yendorian]

I have a straightforward Excel database and want to embed the files in a Word
doc. Each time I try to merge the fields, I get a window in which some of the
fields are displayed but not under their correct column nam (e.g. Surname,
Forename etc) but AutoMergeFie. Can anyone help me to rectify this as I don't
want to automerge. Thanks

 

[Peter Jamieson]

Is there definitely a header row containing column names in your
spreadsheet? Are any columns hidden? Which version of Word/Excel?

Peter Jamieson

 

[Cindy M.]

Hi =?Utf-8?B?WWVuZG9yaWFu?=,

I have a straightforward Excel database and want to embed the files in a Word
doc. Each time I try to merge the fields, I get a window in which some of the
fields are displayed but not under their correct column nam (e.g. Surname,
Forename etc) but AutoMergeFie. Can anyone help me to rectify this as I don't
want to automerge.

I'm confused. You want to use an Excel file embedded in Word document as a mail
merge data source?

Or perhaps we're not agreeing on what "embed" means Do you mean you just
want to merge the data into a Word document? ("Embed" is what happens when you
use Insert/Object/Create from File.)

Which version of Word are we discussing?

Does the range of data you want to merge start in the first row, of the first
worksheet in the workbook?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Yendorian]

Is there definitely a header row containing column names in your
spreadsheet? Are any columns hidden? Which version of Word/Excel?

Peter Jamieson


Hi, Thanks for replying. I am using OFFICE 2003 Pro. I'm new to this game but realise now that my Excel file had empty column headings on Sheet1 which were presumably causing the problem. I've checked them all and it's working fine now.

 

[Yendorian]

Hi =?Utf-8?B?WWVuZG9yaWFu?=,

I'm confused. You want to use an Excel file embedded in Word document as a mail
merge data source?

Or perhaps we're not agreeing on what "embed" means Do you mean you just
want to merge the data into a Word document? ("Embed" is what happens when you
use Insert/Object/Create from File.)

Which version of Word are we discussing?

Does the range of data you want to merge start in the first row, of the first
worksheet in the workbook?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

Hi Cindy,

Thanks for replying and apologies for using the incorrect terms! I just want
to embed the data from EXCEL into a WORD doc.
I'm using OFFICE 2003 Pro.
I've found that the first Sheet on my database contained empty cells which
was causing the problem. I've since rectified this and it seems to be working
properly now.
Thanks for replying