Refresh not working

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?

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Misssy wrote:
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?

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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Misssy wrote:
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?

See 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




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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Misssy wrote:
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?

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" wrote:

See 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




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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Misssy wrote:
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?

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





Misssy wrote:
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" wrote:

See 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




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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Misssy wrote:
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?

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.

"Graham Mayor" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





Misssy wrote:
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" wrote:

See 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




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

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Misssy wrote:
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?