MS WORD • View topic • I need to determine what avery label sheet I used in my merge

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

4 posts • Page 1 of 1

Jump to:

Next

1. Access database to merge with a Word document.
The error is when I try to use an Access database to merge with a Word document. There are a number of dates set up in UK long date format in the database table, ie: 06 April 2004. When I merge this data into Word, the days and dates get 'mixed' up because it converts them back into US format AND it also reads the days as months, and vice versa. I have tried applying various switches to the date field in Word, but this doesn't work for the reason above, and the dates appear in a strange format, eg: 04 0006 04 and things like that. I have half-solved the problem by inputting the dates again, in text format on the Access database so they don't change during the merge process, but this isn't ideal because the dates now are in the wrong order, eg: 19th April comes before 6th April and so on. This also very tedious as I have about 600 records in the table! I could convert the database table into .rtf format as the data source, but this means that the data does not get updated and I would have to do this everytime I make a change to the original table. By the way, the error actually occurs BEFORE any data is merged, ie: when you select the data source and preview it, the dates are wrong. Thanks Nigel
2. Mail merge selects wrong data
Hope this query makes sense - my first post.. I'm using Word2003 mail merge to add address block into standard letters. Data source is Excel 2003 XLS, & I'm using "advanced" filter facility within mail merge. At step 3 of 6, I browse to correct tab within XLS and all data is displayed correctly. I then select "advanced" filtering in column headings, because I want selection: col A = "N" AND col B = blank AND col C = not blank. Data is filtered correctly, so I press OK and carry on with mail merge. At step 5 I find that too many records have been selected because the filter table has been corrupted - for example it now says col B = blank AND col B = not blank, so it selects nearly all records! Any suggestions? My only workaround suggestion is to use Excel to do the filtering, then copy the filtered data to another tab and merge without using the WORD2003 filters. Any other ideas? I'll be very grateful for any suggestions.

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

by TWF0dGluUGh4 » Sun, 06 Nov 2005 02:46:01 GMT

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

Re: I need to determine what avery label sheet I used in my merge

by Doug Robbins - Word MVP » Sun, 06 Nov 2005 08:45:03 GMT

Use a ruler to determine the size of the labels and then check the Avery 
lists.

-- 
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Re: I need to determine what avery label sheet I used in my merge

by TWF0dGluUGh4 » Sun, 06 Nov 2005 11:01:02 GMT

So there is nowhere I can look in the file to see what was picked when it was 
set up?

Re: I need to determine what avery label sheet I used in my merge

by Doug Robbins - Word MVP » Sun, 06 Nov 2005 15:28:10 GMT

No.  Labels are just tables with fixed cell dimensions.  When you pick the 
label type, a document is created with a table with the appropriate 
row/columns numbers and dimensions and from that point, it is just dealt 
with as a table.

-- 
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Similar Threads:

1.determine label sheet used in mail merge

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 
clue?
Thanks,
Matt

2.How do I create a sheet of Avery file folder labels-sheet size

3.How do I create a sheet of Avery file folder labels-sheet size 836

I know there are templates within even old versions of Word which interface 
with many Avery label types (incl 8366, file folder labels) but I can't 
locate where or how to create a sheet of these labels anywhere.  Only "Mail 
Merge" options are available and the interface for file folder labels limit 
you to the same label throughout the entire sheet or to printing one single 
label.  Please include detailed directions -- I need all the help I can get.  
PS I could not find answer on knowwledgebase, forum or in the product. 
-- 
Thanks a million!
Sincerely,
Leslie

4.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.

5.need additional label sheets in mail merge

I'm using mail merge to print labels generated from an excel data file.  All 
is well except I don't understand why only one page of labels will be 
generated when I've selected more than 30 entries from the data list to be 
printed.  I'm using msword2007 and didn't have this trouble in 03 version.  
The merger would generate enough pages to print all selected data entries.  
This way, I'm having to print or create a new merger, 30 at a time which is 
creating much more work for me.  Any suggestions would greatly be appreciated.

Thanks

6. need bates label template for avery label 5167

7. Re-using Partial Sheets of Labels in Merge

8. problem with label creep using Avery 5163 Labels?

4 posts • Page 1 of 1

Return to MS WORD

Who is online

Users browsing this forum: No registered users and 2 guest