 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2004Refresh 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?  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have created mailing labels with Word, using an Excel as the data > source. [quoted text clipped - 8 lines] > 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? > Did you re-run the merge after adding the data? > [quoted text clipped - 10 lines] > > Am I making an inccorect assumption that this should refresh > > automatically? Any ideas? See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I went through the options on the toolbar, but did not see a way to > merge - how can I do that? [quoted text clipped - 24 lines] >>> 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. > See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm > [quoted text clipped - 26 lines] > >>> 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. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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 [quoted text clipped - 52 lines] >>>>> 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. > 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 [quoted text clipped - 62 lines] > >>>>> Am I making an inccorect assumption that this should refresh > >>>>> automatically? Any ideas?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.