Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
Hello to all. I've never used a service such as this before.
Hopefully i'll do this right . I have Word2002 at home, and do not have any problems. At work we have Word 2000 running on Win 2000 Pro. The problem I am having is with the Mail Merge. Specifically, it is when I am trying to insert a merge field in my form letter. I have produced a form letter in Word. I also created an address list in Excel to use as my data source. I have the Mail Merge toolbar displayed. When I click on the "Insert Merge Field" button, I see only two choices---NAME or AutoMergeField. I do not see the header choices in my data source. I have tried countless times to fix this, to no avail. Could someone please tell me just what it is I'm doing wrong? I don't know if I have to manually add fields to the "button" (if so, I don't know how) or if I need to do something special to my Excel sheet to have Word recognise it (again, I don't know how). About my data source--there are multiple sheets in the workbook, but all but one have been hidden. Thanks in advance for any help that you can provide. Don |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
I have Word2002 at home, and do not have any problems. At work we have
Word 2000 running on Win 2000 Pro. The problem I am having is with the Mail Merge. Specifically, it is when I am trying to insert a merge field in my form letter. Right... Word 2000 uses a different default connection method to Excel, which is why you'll see disconcerting differences. I have produced a form letter in Word. I also created an address list in Excel to use as my data source. I have the Mail Merge toolbar displayed. When I click on the "Insert Merge Field" button, I see only two choices---NAME or AutoMergeField. I do not see the header choices in my data source. This usually means that that data in Excel does not start in cell A1 on the first sheet in the workbook. IF you apply a named range to the data source, then you can use ODBC to pick it up from anywhere in the workbook. In order to use ODBC (instead of Word 2000's default DDE): activate the Select Method checkbox in the Open Data Source dialog box. You should get a list offering a number (up to three) connection methods. Select ODBC. 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 :-) |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
To add to what Cindy has said, you need to be sure there are no blank rows
between your heading row and the data record rows. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cindy M -WordMVP-" wrote in message news:VA.0000c177.018186c3@speedy... I have Word2002 at home, and do not have any problems. At work we have Word 2000 running on Win 2000 Pro. The problem I am having is with the Mail Merge. Specifically, it is when I am trying to insert a merge field in my form letter. Right... Word 2000 uses a different default connection method to Excel, which is why you'll see disconcerting differences. I have produced a form letter in Word. I also created an address list in Excel to use as my data source. I have the Mail Merge toolbar displayed. When I click on the "Insert Merge Field" button, I see only two choices---NAME or AutoMergeField. I do not see the header choices in my data source. This usually means that that data in Excel does not start in cell A1 on the first sheet in the workbook. IF you apply a named range to the data source, then you can use ODBC to pick it up from anywhere in the workbook. In order to use ODBC (instead of Word 2000's default DDE): activate the Select Method checkbox in the Open Data Source dialog box. You should get a list offering a number (up to three) connection methods. Select ODBC. 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 :-) |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
Cindy;
I will definately try that. I was also reading elsewhere that after opening my data source, when I go back to my form letter, before proceeding I should save my main doc first. This "binds" the data source to the form letter. If this is true, I have not done that. My spreadsheet starts with the header row in A1. But a couplre of the names in the header row are written like this: Street_Address. Will Word not recognise the underscore? Just wondering. Thanks for your suggestions. I will try them out soon. Don Cindy M -WordMVP- wrote: I have Word2002 at home, and do not have any problems. At work we have Word 2000 running on Win 2000 Pro. The problem I am having is with the Mail Merge. Specifically, it is when I am trying to insert a merge field in my form letter. Right... Word 2000 uses a different default connection method to Excel, which is why you'll see disconcerting differences. I have produced a form letter in Word. I also created an address list in Excel to use as my data source. I have the Mail Merge toolbar displayed. When I click on the "Insert Merge Field" button, I see only two choices---NAME or AutoMergeField. I do not see the header choices in my data source. This usually means that that data in Excel does not start in cell A1 on the first sheet in the workbook. IF you apply a named range to the data source, then you can use ODBC to pick it up from anywhere in the workbook. In order to use ODBC (instead of Word 2000's default DDE): activate the Select Method checkbox in the Open Data Source dialog box. You should get a list offering a number (up to three) connection methods. Select ODBC. 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 :-) |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
Suzanne--I have made sure from the beginning that all rows/columns are
full. Thank you. Don Suzanne S. Barnhill wrote: To add to what Cindy has said, you need to be sure there are no blank rows between your heading row and the data record rows. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cindy M -WordMVP-" wrote in message news:VA.0000c177.018186c3@speedy... I have Word2002 at home, and do not have any problems. At work we have Word 2000 running on Win 2000 Pro. The problem I am having is with the Mail Merge. Specifically, it is when I am trying to insert a merge field in my form letter. Right... Word 2000 uses a different default connection method to Excel, which is why you'll see disconcerting differences. I have produced a form letter in Word. I also created an address list in Excel to use as my data source. I have the Mail Merge toolbar displayed. When I click on the "Insert Merge Field" button, I see only two choices---NAME or AutoMergeField. I do not see the header choices in my data source. This usually means that that data in Excel does not start in cell A1 on the first sheet in the workbook. IF you apply a named range to the data source, then you can use ODBC to pick it up from anywhere in the workbook. In order to use ODBC (instead of Word 2000's default DDE): activate the Select Method checkbox in the Open Data Source dialog box. You should get a list offering a number (up to three) connection methods. Select ODBC. 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 :-) |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
Hi Don,
I will definately try that. I was also reading elsewhere that after opening my data source, when I go back to my form letter, before proceeding I should save my main doc first. This "binds" the data source to the form letter. If this is true, I have not done that. My spreadsheet starts with the header row in A1. But a couplre of the names in the header row are written like this: Street_Address. Will Word not recognise the underscore? Just wondering. the underscore shouldn't be a problem. But are you sure this is the first sheet 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 :-) |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
Cindy M -WordMVP- wrote: Hi Don, I will definately try that. I was also reading elsewhere that after opening my data source, when I go back to my form letter, before proceeding I should save my main doc first. This "binds" the data source to the form letter. If this is true, I have not done that. My spreadsheet starts with the header row in A1. But a couplre of the names in the header row are written like this: Street_Address. Will Word not recognise the underscore? Just wondering. the underscore shouldn't be a problem. But are you sure this is the first sheet 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 :-) Cindy, It is the only sheet "displayed" in the workbook. All other sheets have benn hidden. If all sheets were viewable, it would not be the first. I think this may be a problem. I keep seeing "Aaron" displayed in the mergefield NAME, when "Dr. Aaron Smith" is in the NAME column on the sheet that is displayed. I will give this another try. Thank you for taking the time to check back. Don |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail Merge problem with Word 2000
Hi Don,
It is the only sheet "displayed" in the workbook. All other sheets have benn hidden. If all sheets were viewable, it would not be the first. I think this may be a problem. I keep seeing "Aaron" displayed in the mergefield NAME, when "Dr. Aaron Smith" is in the NAME column on the sheet that is displayed. Yep, that would do it :-) Problem is the old DDE technology was written to communicate with Excel back in the days when it supported only one worksheet / workbook. If it's not physically the first sheet, mail merge can't "see" it properly through a DDE connection. 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Change paper size; Word changes to invalid margins | New Users | |||
After merge I need to see the letters under the prompt box to edit | Mailmerge | |||
Word 2000 mail merge documents won't save Access 2000 data source | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge |