Hi John,
My friend and I worked on the merge for 3 hours this morning and figured it
out.
I viewed the demo and followed it step by step BUT the demo failed to add in
you need to click on "UPDATE LABELS" prior to the PREVIEW... Here is what I
did;
1.) Click on Start Merged file - select staiton (label, envelops etc..)
2.) Select Avery code number listed on the package of you labels
3.) Click on Select Reciepts; (my file was in excel) MS will add NEXT
RECORD to each label except first label
4.) Edit Recipient List (delete any blank records) OKAY
5.) Address Block; Map fields - first label will be coded with
addressBLock 6.) 6.) Click ON "UPDATE LABELS"will look like this «Next
Record»«AddressBlock»
7.) click on "Preview Results address will appear!!!
To add a new discussion - click on NEW in the discussion database
Does anyone know how to SAVE and forward the updated lable file without
having to send the orginal excel file?
thanks
"John A" wrote:
-- Bee... sorry I can't help but I'm experiencing the exact issue. However,
I have my address list (for Christmas cards) neatly created in an Excel work
sheet but when I use WordToolsLetters & MailingsMail MergeLabels etc it
doesn't work. (I think my problem may have something to do with the Browse to
the saved file part...)
BTW: how does a newbee to the Discussion broup post a New question?
Thanks for your help
"Bee" wrote:
Hello,
I am trying to merge a file with 100 mail addresses using the label maker.
I have successfully add the address block in the first cell, and the
next record in the following cells. When I press preview results
address only populates in the fist field and the others are blank. What am
I doing wrong?
I have gone through step by step instructions as indicated in the demo...
but my labels informaiton does not display in each cell.
Also, if I have merged 100 mail addresses shouldn't I have more then one page?
I"m using Avery 5160...
thanks!
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...merge.fi elds