Mail Merge quirkiness 1

[lespaul]

I have a word template called VenireLabel. I created this template using Avery labels. It is a sheet of 20 x 4 labels. I perform my mail merge through a Delphi program (with Word.Visible = False) and it works.

Here's the problem, for some reason when it prints there are 21 lines of labels! I have deleted a row from my template so that there are only 19 rows (supposing that it would add one additional and then be right), but it still writes out 21 lines of labels. My users are then forced to correct all the labels that printed on the bottom of the page where there is NO label.

I am using Word 2000 with an Excel 2000 worksheet to store my label information. Does anyone have any idea how I can eliminiate the extra row!!?

Thanks for any insight into this VERY ANNOYING little problem. Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[Dreamboat]

Which label template did you use? What's the number of the label? Are you really using those labels? How many does it say it will print? Are you sure you don't have an extra table row in there somewhere? Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[lespaul]

I am using the Avery 5167 label. Yes I am really using those labels. No there is no extra row. I just tried recreating the template just to make sure there wasn't an extra row and the same thing happens. When the template is opened there are 20 rows of labels. When manually testing the label template, I press the mail merge button and when the merge is complete there are 21 rows of data on each sheet of labels. Even when I delete a row, I still have 21 rows of data when the merge is complete.

Thanks for helping! I have seen lots of your postings and am always impressed by your knowledge of Word & Excel!

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[Dreamboat]

Thanks for your nice words, Leslie!

I'd be happy to take a look at your template. Having the data would be nice, but if you must, just send me data with at least one record, even if the name is Mickey Mouse.

Anne@TheOfficeExperts.com Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[Dreamboat]

Wow. I cannot get it to create 21 rows.
Do me a favor and try this:

Open the template directly.
Put a bottom margin on the page of maybe .4 or .5"

Tell me if that helps.
When mail merging, it will create rows until it's done with the records. I think that first row that ought to be on the next page is squeezing into the bottom of the first page. Why?

Maybe because of this (copied from another place that I wrote it):
____
Different printers need more space at the bottom of the sheet of paper to allow the rollers to pull the paper through the printer. Rule of thumb: the less you paid for your printer, the more of the paper it uses. Thus, if you set your document up for a printer that allows a 1/2" margin at the bottom, and then take it to another PC that is connected only to a printer that requires a 0.6" margin at the bottom, you may end up with extra pages because the page breaks (manual or automatic) now break "sooner".

To determine the minimum margins for your printer: Open a blank document. Set all margins to zero, and hit OK. You should be told that your margins are outside of the printable area, and choose to Fix or Ignore it. Choose FIX. Go back into the margins and see what they have been changed to. These are the minimum margins of which your printer is capable. You may want to set your Word default margins to be at least as large as the minimums.
_____

Perhaps your printer is capable of much smaller margins than most. So, Avery gets you into trouble by assuming. I mean....your bottom margin is ZERO. Probably so that most printers will just print as far to the bottom as they can. After all...their templates are nothing more than tables--it's not like they have some kind of control other than the table setup.

Hope it helps.
I'll keep looking at it if it doesn't.
Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[lespaul]

Thanks! I changed the bottom margin from 0 to .5 and that works like a charm, only twenty rows of data!

Have a star!

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

 

[Dreamboat]

I'm sooo glad! Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[lespaul]

Me too! and I'm sure my users will be too!

Thanks! Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!