Refresh not working

[Misssy]

I have created mailing labels with Word, using an Excel as the data source.
When I add new records to the datasource, it does not show up in the labels.
Upon opening the labels after adding data, I get a message "Opening this document with run the following SQL command...etc.." which states the correct datasource. I can also look at the datasource with the Mail Merge recipients button and see my new records in that list. However, my label document does not have the new records added anywhere (I searched in case it inserted it somewhere in the middle). Am I making an inccorect assumption that this should refresh automatically? Any ideas?

 

[Graham Mayor]

Did you re-run the merge after adding the data?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Misssy]

I went through the options on the toolbar, but did not see a way to merge - how can I do that?

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Misssy]

OK, I read your document, and used the "Merge to a new document" button. I selected "all" in the records to merge option. It creates a new document that looks like my orginal. However, something goes very wrong at this point.

The merge must be happening, I can see Word trying to repaiginate the document as quickly as it can, but the number of pages rapidly goes beyond what I should expect. My original set of labels was 14 pages. I canceled this new document when it was over 3300 pages and climbing....

In your document you say to go re-read the instructions if this merge process doesn't work, but I'm not sure what is messing up here and what I should re-read. Thanks for your time.

 

[Graham Mayor]

Hmmm. It is difficult to envisage what could have gone wrong when I don't
have either your address list nor your template, but it seems that the
process has gone into a continuous loop - either that or it is attempting to
merge all the empty rows in the Excel file.

Can I suggest that you create a new label merge along the lines suggested on
the web page - which only takes a couple of minutes to set up (I tested it
again before responding in case there was something I was missing) - and
merge that file to a new document.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Misssy]

Ok, I tried following your method. I checked and I am using Word 2003, if that matters. I got the same result. My first set of labels are perfect. I also looked at the data source, scrolled down and checked that my new record was added on that list.

The next time I open them, hit the "merge to new document" button. I can see in the status text at the bottom of the page as says "Word is merging records", it counts through my 400 records, pops open the page, then starts repagnating itself, way beyond the 14 pages that I should be getting. If I look into these labels, it has not added my new one.

I have been using Word since 1989, and am MOUS expert level in Word a few versions back, so I generally know what I am doing. This is really bizarre.