auto merge field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yendorian - 11 Jun 2007 11:26 GMT

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

Reply to this Message

Peter Jamieson - 11 Jun 2007 20:09 GMT

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

Peter Jamieson

>I have a straightforward Excel database and want to embed the files in a
>Word
[quoted text clipped - 4 lines]
> don't
> want to automerge. Thanks

Reply to this Message

Yendorian - 11 Jun 2007 22:36 GMT

> Is there definitely a header row containing column names in your
> spreadsheet? Are any columns hidden? Which version of Word/Excel?
[quoted text clipped - 10 lines]
>
> 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.

Reply to this Message

Cindy M. - 11 Jun 2007 20:47 GMT

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

Reply to this Message

Yendorian - 11 Jun 2007 22:41 GMT

> Hi =?Utf-8?B?WWVuZG9yaWFu?=,
>
[quoted text clipped - 25 lines]
>
> 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

Reply to this Message