Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail 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 |
#2
|
|||
|
|||
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 "Shadow" wrote in message ... 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 |
#3
|
|||
|
|||
No they are still all coming up blank. I even tried using the wizard and
still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#4
|
|||
|
|||
Want to send your files? Are you sure your text isn't hidden or something?
******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#5
|
|||
|
|||
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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#6
|
|||
|
|||
See where what you are doing differs from
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#7
|
|||
|
|||
See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Hope 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 "Shadow" wrote in message ... 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#8
|
|||
|
|||
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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#9
|
|||
|
|||
In the mailmerge main document, what do you see if you use Alt+F9 to toggle
on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#10
|
|||
|
|||
{NEXT}{ADRESSBLOCK/f
"_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#11
|
|||
|
|||
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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#12
|
|||
|
|||
Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just
ry losding that? Could it be my program? "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#13
|
|||
|
|||
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? -- Hope 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 "Shadow" wrote in message ... Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just ry losding that? Could it be my program? "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#14
|
|||
|
|||
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. "Doug Robbins" wrote: 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? -- Hope 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 "Shadow" wrote in message ... Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just ry losding that? Could it be my program? "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#15
|
|||
|
|||
What are the field names in the Excel file?
-- Hope 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 "Shadow" wrote in message news 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. "Doug Robbins" wrote: 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? -- Hope 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 "Shadow" wrote in message ... Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just ry losding that? Could it be my program? "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#16
|
|||
|
|||
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. "Doug Robbins" wrote: What are the field names in the Excel file? -- Hope 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 "Shadow" wrote in message news 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. "Doug Robbins" wrote: 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? -- Hope 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 "Shadow" wrote in message ... Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just ry losding that? Could it be my program? "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#17
|
|||
|
|||
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. -- Hope 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 "Shadow" wrote in message ... 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. "Doug Robbins" wrote: What are the field names in the Excel file? -- Hope 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 "Shadow" wrote in message news 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. "Doug Robbins" wrote: 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? -- Hope 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 "Shadow" wrote in message ... Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just ry losding that? Could it be my program? "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
#18
|
|||
|
|||
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 "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... 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. "Doug Robbins" wrote: What are the field names in the Excel file? -- Hope 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 "Shadow" wrote in message news 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. "Doug Robbins" wrote: 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? -- Hope 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 "Shadow" wrote in message ... Yes. Someone has offered me the 2003 verison of Word and Excel. Should I just ry losding that? Could it be my program? "Doug Robbins" wrote: 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. -- Hope 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 "Shadow" wrote in message ... {NEXT}{ADRESSBLOCK/f "_FIRST0__LAST0_ _SUFFIX0_ _STREET1_ _STREET2_ _CUTY_,_STATE__POSTAL_"11033\c 0 \e ""} "Doug Robbins" wrote: In the mailmerge main document, what do you see if you use Alt+F9 to toggle on the display of field codes? -- Hope 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 "Shadow" wrote in message ... 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? "Graham Mayor" wrote: See where what you are doing differs from http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Shadow wrote: 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!! "Anne Troy" wrote: Want to send your files? Are you sure your text isn't hidden or something? ******************* ~Anne Troy www.OfficeArticles.com "Shadow" wrote in message ... No they are still all coming up blank. I even tried using the wizard and still nothing. "Anne Troy" wrote: 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 "Shadow" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Mail Merge Problem w/ MS Word 2000 | Mailmerge |