determine label sheet used in mail merge



  • 1. MailMerge change of datasource
    Hi We have a number of Word letters that are the templates for Mail mereges using MS Access as the datasource. However, we have recently had our database tidied up, with object name being table consistent (tables all now start tbl etc). Of course this has upset our mail merges with the Word documents now un able to find the data sources. Is there an easier way to change the datasource, other than having to open up each document in turn and relink, does anyone know? Many thanks Alex
  • 2. Add 2 spaces to end of sentance?
    I have constructed a number of sentences in excel. Each sentence represents a field that I ref in my mail merge doc. Issue: Depending on the situation some sentences are needed and some are not, so putting a double space after each field in word, may result in 4 spaces after a sentance if one field/sentence is not needed. When I add spaces to the sentences in excel, word during the mail merge process removes/ignors the spaces. Any thoughts? Thanks in advance
  • 3. Problem importing recipients from nominated Excel worksheet
    I'm attempting to do a mail merge on a letter created in Word 2007. When I chose "Select Recipients", I then selected "Use existing list" then browsed to locate the correct Excel 2007 file. The correct worksheet was identified. No problem so far. However, when I selected the worksheet, the "Select table" screen shows an entirely different file name and location. If I arrow down, other file names and locations are listed, but not the one I selected. There is nothing in the table list. Any thoughts on a solution? -- ajb
  • 4. Mail Merge is attaching .thmx and .xml files
    I am trying to mail merge but on my test merge it always attaches a .thmx and .xml file to the email. I am using 2007 trial edition and have even cut and pasted the content from the word doc to another word doc but the attachments are still there. they are themedate.thmx and colorschememapping.xml Help?
  • 5. next record placement
    Merging 2 fields into form letter: Two copies of the letter side by side on 1 page --that's what the stationary requires. I inserted next record in first copy after the merged fields. Great--second copy has the second record. But when previewing the next page, the 2nd records fields now appear in the first copy; sure enough, the 3rd record is in the second copy. etc etc. Do I need an "if" command here? I've tried putting "next record" in 2nd copy of the letter to avail. -- Thanks

determine label sheet used in mail merge

Postby TWF0dGluUGh4 » Sun, 06 Nov 2005 03:15:03 GMT

I need to know how to determine what Avery label sheet I used in a mail merge 
in Word 2003 using an Excel spreadsheet for data. I am on XP. Anybody have a 

Re: determine label sheet used in mail merge

Postby Graham Mayor » Sun, 06 Nov 2005 15:16:33 GMT

This information isn't recorded, but it shouldn't matter - see 

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

My web site
Word MVP web site  http://www.**--****.com/ 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Similar Threads:

1.I need to determine what avery label sheet I used in my merge

I can't find where to look to determine the Avery label sheet number I used 
in a label mail merge. Anyone know?

2.Mail Merge Labels using partial label sheets

I need to start my Mail Merge labels halfway down the page because I've 
already used part of my label sheet.  How do I get the setup of the page to 
shift and begin further down?  Thanks.

3.Mailing labels-printing using partial sheet of labels

Does anyone know how to change the starting location when printing labels.  I 
have an application that requires printing spine labels for a group of 
libraries. The problem is that we may only need to print 4 or 5 labels at a 
time.  Consequentially we end up with a lot of pages of labels that are 
missing the top and bottom row of labels.  We want to be able to use the rest 
of the labels as well.  I realize that we can cut and paste from row to row 
however, I have about 30 librarians and for the majority of them it is hard 
enough for them generate the labels.  Any help would be appreciated.

4.Print multiple mailing labels in "middle" of a sheet using Mai

5.Print multiple mailing labels in "middle" of a sheet using Mailmer

How do I "tell" Mailmerge to start printing a group of mailing labels in the 
"middle" of a sheet of labels?

6. Re-using Partial Sheets of Labels in Merge

7. Mail merge & labels - problems with multiple sheets

8. need additional label sheets in mail merge

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 25 guest