auto merge field Yendorian 6/11/2007 10:26:00 AM 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

Re: auto merge field "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/11/2007 7:09:24 PM Is there definitely a header row containing column names in your spreadsheet? Are any columns hidden? Which version of Word/Excel? Peter Jamieson "Yendorian" <Yendorian[ at ]discussions.microsoft.com> wrote in message news:EAEEACF3-87CF-48AD-8BB0-A3DBF327FC7F[ at ]microsoft.com... [Quoted Text] >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

Re: auto merge field Cindy M. <C.Meister-C[ at ]hispeed.ch> 6/11/2007 7:47:36 PM Hi =?Utf-8?B?WWVuZG9yaWFu?=, [Quoted Text] > 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 :-)

Re: auto merge field Yendorian 6/11/2007 9:36:01 PM "Peter Jamieson" wrote: [Quoted Text] > Is there definitely a header row containing column names in your > spreadsheet? Are any columns hidden? Which version of Word/Excel? > > Peter Jamieson > "Yendorian" <Yendorian[ at ]discussions.microsoft.com> wrote in message > news:EAEEACF3-87CF-48AD-8BB0-A3DBF327FC7F[ at ]microsoft.com... > >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 > > 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.

Re: auto merge field Yendorian 6/11/2007 9:41:00 PM "Cindy M." wrote: [Quoted Text] > 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 :-) > > 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