 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2005Mail Merge Word 2002 HELP!!!
I am tryign to mail merge in Word 2002 from Excel. I am using the wizard and everything seems to be going great. Then when it says it is going to merge the page labels are blank even though it says that it has merged. What am I doing wrong???? I really need this soon if anyone can help!!! Thanks Go to View-->Toolbars and choose the Mail Merge toolbar. Make sure you click the "Merge to new document" button. Any help? ******************* ~Anne Troy www.OfficeArticles.com > I am tryign to mail merge in Word 2002 from Excel. I am using the wizard and > everything seems to be going great. Then when it says it is going to merge [quoted text clipped - 3 lines] > > Thanks No they are still all coming up blank. I even tried using the wizard and still nothing. > Go to View-->Toolbars and choose the Mail Merge toolbar. Make sure you click > the "Merge to new document" button. Any help? [quoted text clipped - 11 lines] > > > > Thanks Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com > No they are still all coming up blank. I even tried using the wizard and > still nothing. [quoted text clipped - 14 lines] > > > > > > Thanks No I don't think so. How can I check to see. I am so lost and I am trying to do these labels for my church and I am ready to give up!! > Want to send your files? Are you sure your text isn't hidden or something? > ******************* [quoted text clipped - 24 lines] > > > > > > > > Thanks See where what you are doing differs from http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > No I don't think so. How can I check to see. I am so lost and I am > trying to do these labels for my church and I am ready to give up!! [quoted text clipped - 24 lines] >>>>> >>>>> Thanks It is still doing it and I am doing everything as your instrctions say. Could it be my program? If it is what do I do? > See where what you are doing differs from > http://www.gmayor.com/mail_merge_labels_with_word_xp.htm [quoted text clipped - 27 lines] > >>>>> > >>>>> Thanks In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > It is still doing it and I am doing everything as your instrctions say. > Could [quoted text clipped - 31 lines] >> >>>>> >> >>>>> Thanks {NEXT}{ADRESSBLOCK/f "<<_FIRST0_>><<_LAST0_>><< _SUFFIX0_>> <<_STREET1_ >><<_STREET2_ >><<_CUTY_>><<,_STATE_>><<_POSTAL_>>"11033\c 0 \e ""} > In the mailmerge main document, what do you see if you use Alt+F9 to toggle > on the display of field codes? [quoted text clipped - 34 lines] > >> >>>>> > >> >>>>> Thanks Do the following field names correspond exactly to the fields in your datasource? <<_FIRST0_>><<_LAST0_>><< _SUFFIX0_>> <<_STREET1_ >><<_STREET2_ >><<_CUTY_>><<,_STATE_>><<_POSTAL_>> I would suggest that instead of using the AddressBlock, you insert the actual mergefields that you want to use in the configuration that you want them. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > {NEXT}{ADRESSBLOCK/f > "<<_FIRST0_>><<_LAST0_>><< [quoted text clipped - 44 lines] >> >> >>>>> >> >> >>>>> Thanks Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just ry losding that? Could it be my program? > Do the following field names correspond exactly to the fields in your > datasource? [quoted text clipped - 57 lines] > >> >> >>>>> > >> >> >>>>> Thanks It's extemely unlikely that it is a problem with the software. Almost certainly it's a problem with the datasource or the main document. Have you tried inserting the merge fields directly rather that using the address block? SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Yes. Someone has offered me the 2003 verison of Word and Excel. Should I > just [quoted text clipped - 67 lines] >> >> >> >>>>> >> >> >> >>>>> Thanks I just tried to get do labels from my address book instead of from my Excel file and it worked fine. Is it the Excel file? I am taking a file from a zip program and downloanding it to Excel and saving it as an Excel file then trying to do the mail merge. > It's extemely unlikely that it is a problem with the software. Almost > certainly it's a problem with the datasource or the main document. Have you [quoted text clipped - 72 lines] > >> >> >> >>>>> > >> >> >> >>>>> Thanks What are the field names in the Excel file? SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP >I just tried to get do labels from my address book instead of from my Excel > file and it worked fine. Is it the Excel file? I am taking a file from a [quoted text clipped - 90 lines] >> >> >> >> >>>>> >> >> >> >> >>>>> Thanks Well I finalyy got that to work but now it is only putting the name, city, state & zip, no street address. My headings in Excel are last, first, street 1, city, state & zip. > What are the field names in the Excel file? > [quoted text clipped - 92 lines] > >> >> >> >> >>>>> > >> >> >> >> >>>>> Thanks If you are still using the AddressBlock, do not use it. Just insert those field names in the configuration that you desire them to appear: <<first>> <<last>> <<street1>> <<city>> <<state>> <<zip>> If there is a space between street and 1 in your Excel spreadsheet (as it appears that there maybe because the email program has inserted a linebreak between the two, that is why Street is not appearing. You cannot have a space in a field name. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Well I finalyy got that to work but now it is only putting the name, city, > state & zip, no street address. My headings in Excel are last, first, [quoted text clipped - 112 lines] >> >> >> >> >> >>>>> >> >> >> >> >> >>>>> Thanks Thank you so much!!!! it is finally working. I guess I was just a mail merge idiot!! Thank you for your time it was VERY helpful. Sarah > If you are still using the AddressBlock, do not use it. Just insert those > field names in the configuration that you desire them to appear: [quoted text clipped - 124 lines] > >> >> >> >> >> >>>>> > >> >> >> >> >> >>>>> Thanks See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_labels_with_word_xp.htm SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > No I don't think so. How can I check to see. I am so lost and I am trying > to [quoted text clipped - 32 lines] >> > > > >> > > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.