Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel as mailmerge data source
I am using an Excel spreadsheet as a mailmerge data source in Word 2003. I
have the field names in the first column and no blank record rows. After I have selected the Excel file as the data source in the mailmerge wizard, the Select Table window shows Sheet1$ and Sheet1$_ Why do I get these alternatives and does it matter which one I pick? Wanting to understand as well as get the thing to work properly! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel as mailmerge data source
Hi ?B?TWFyeSBBbm4=?=,
I think you're alright no matter which one you pick (as long as you don't go and rename the sheet); I'd tend to go with the first of the two. I can't recall having ever known why both of these show, but I'm pretty sure it has something to do with how the OLE DB provider used to connect to Excel picks up the sheet names. (Excel isn't a true database, so there are "oddities" when using database stuff to interface with it.) I am using an Excel spreadsheet as a mailmerge data source in Word 2003. I have the field names in the first column and no blank record rows. After I have selected the Excel file as the data source in the mailmerge wizard, the Select Table window shows Sheet1$ and Sheet1$_ Why do I get these alternatives and does it matter which one I pick? Wanting to understand as well as get the thing to work properly! Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel as mailmerge data source
OK, thanks Cindy
"Cindy M -WordMVP-" wrote: Hi ?B?TWFyeSBBbm4=?=, I think you're alright no matter which one you pick (as long as you don't go and rename the sheet); I'd tend to go with the first of the two. I can't recall having ever known why both of these show, but I'm pretty sure it has something to do with how the OLE DB provider used to connect to Excel picks up the sheet names. (Excel isn't a true database, so there are "oddities" when using database stuff to interface with it.) I am using an Excel spreadsheet as a mailmerge data source in Word 2003. I have the field names in the first column and no blank record rows. After I have selected the Excel file as the data source in the mailmerge wizard, the Select Table window shows Sheet1$ and Sheet1$_ Why do I get these alternatives and does it matter which one I pick? Wanting to understand as well as get the thing to work properly! Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2002 cannot find its Excel data source for mail merge | Mailmerge | |||
"Word was unable to open the Excel data source" Asp.net Mailmerge | Mailmerge | |||
Formatting a word mailmerge with Excel data source | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mailmerge wont see Added Excel Data source Columns | Mailmerge |