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