A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

why do I get [a lot of] duplicate labels when I use mail merge?



 
 
Thread Tools Display Modes
  #11  
Old January 7th, 2009, 05:08 AM posted to microsoft.public.word.mailmerge.fields
Robert
external usenet poster
 
Posts: 717
Default why do I get [a lot of] duplicate labels when I use mail merge

because I am not a office 2007 wiz and I was following the microsoft tutorial
on address label creation. Does not do anyone much good if their tutorials
instructions don't even work.

"Doug Robbins - Word MVP" wrote:

It is hard to say what is going wrong, but why don't you just create the
labels in Access?

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

"Robert" wrote in message
...
I am having the exact same problem! Using '07' with mail merge of data from
access db the print preview shows a single page of the 30 addresses I wish
to
print address labels for, yet when I print I get 3 pages of the first
record
of the preview! All records with the exception of the very first has
NextRecord prior to the addressblock and so far nothing I have tried is
allowing me to print ONE page of 30 labels which of course is also the
number
of records I have selected from my db. HELP!

Robert

"Graham Mayor" wrote:

If you chose to install 2007 alongside Word 2003, both should be
available,
though not without some conflicts - see
http://www.gmayor.com/Toolbars_in_word_2007.htm

From your description of the merge it is impossible to spot the
deliberate
mistake, however I suspect you are previewing the source document and not
completing the merge. You must merge to a new document or the printer to
see
the merge as it is completed see
http://www.gmayor.com/merge_labels_with_word_2007.htm.
http://www.gmayor.com/graphics_on_labels.htm and
http://www.gmayor.com/mail_merge_graphics.htm

This was exactly the same in 2003!

--

Graham Mayor - Word MVP

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




Logikal1 wrote:
I'm trying to print out ONE set of labels using the new 2007 WORD
[which has disabled my 2003 version so i'm really stuck]. I made a
mail merge of approximately 100 titles and added graphics etc. But,
when I went to preview I got a shocl: I get over 390 labels due to
constant duplications! They're supposed to be in alphabetical order,
yet they keep jumping back and restarting at different points. How
can I correct this problem?






  #12  
Old January 7th, 2009, 08:40 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default why do I get [a lot of] duplicate labels when I use mail merge

Take a look at http://www.gmayor.com/merge_labels_with_word_2007.htm and see
where what you are doing differs from that.

--

Graham Mayor - Word MVP

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



Robert wrote:
because I am not a office 2007 wiz and I was following the microsoft
tutorial on address label creation. Does not do anyone much good if
their tutorials instructions don't even work.

"Doug Robbins - Word MVP" wrote:

It is hard to say what is going wrong, but why don't you just create
the labels in Access?

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

"Robert" wrote in message
...
I am having the exact same problem! Using '07' with mail merge of
data from access db the print preview shows a single page of the 30
addresses I wish to
print address labels for, yet when I print I get 3 pages of the
first record
of the preview! All records with the exception of the very first has
NextRecord prior to the addressblock and so far nothing I have
tried is allowing me to print ONE page of 30 labels which of course
is also the number
of records I have selected from my db. HELP!

Robert

"Graham Mayor" wrote:

If you chose to install 2007 alongside Word 2003, both should be
available,
though not without some conflicts - see
http://www.gmayor.com/Toolbars_in_word_2007.htm

From your description of the merge it is impossible to spot the
deliberate
mistake, however I suspect you are previewing the source document
and not completing the merge. You must merge to a new document or
the printer to see
the merge as it is completed see
http://www.gmayor.com/merge_labels_with_word_2007.htm.
http://www.gmayor.com/graphics_on_labels.htm and
http://www.gmayor.com/mail_merge_graphics.htm

This was exactly the same in 2003!

--

Graham Mayor - Word MVP

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




Logikal1 wrote:
I'm trying to print out ONE set of labels using the new 2007 WORD
[which has disabled my 2003 version so i'm really stuck]. I made
a mail merge of approximately 100 titles and added graphics etc.
But, when I went to preview I got a shocl: I get over 390 labels
due to constant duplications! They're supposed to be in
alphabetical order, yet they keep jumping back and restarting at
different points. How can I correct this problem?



  #13  
Old January 7th, 2009, 09:56 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default why do I get [a lot of] duplicate labels when I use mail merge

Access has a Report Wizard for the creation of labels.

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

"Robert" wrote in message
...
because I am not a office 2007 wiz and I was following the microsoft
tutorial
on address label creation. Does not do anyone much good if their tutorials
instructions don't even work.

"Doug Robbins - Word MVP" wrote:

It is hard to say what is going wrong, but why don't you just create the
labels in Access?

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

"Robert" wrote in message
...
I am having the exact same problem! Using '07' with mail merge of data
from
access db the print preview shows a single page of the 30 addresses I
wish
to
print address labels for, yet when I print I get 3 pages of the first
record
of the preview! All records with the exception of the very first has
NextRecord prior to the addressblock and so far nothing I have tried is
allowing me to print ONE page of 30 labels which of course is also the
number
of records I have selected from my db. HELP!

Robert

"Graham Mayor" wrote:

If you chose to install 2007 alongside Word 2003, both should be
available,
though not without some conflicts - see
http://www.gmayor.com/Toolbars_in_word_2007.htm

From your description of the merge it is impossible to spot the
deliberate
mistake, however I suspect you are previewing the source document and
not
completing the merge. You must merge to a new document or the printer
to
see
the merge as it is completed see
http://www.gmayor.com/merge_labels_with_word_2007.htm.
http://www.gmayor.com/graphics_on_labels.htm and
http://www.gmayor.com/mail_merge_graphics.htm

This was exactly the same in 2003!

--

Graham Mayor - Word MVP

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




Logikal1 wrote:
I'm trying to print out ONE set of labels using the new 2007 WORD
[which has disabled my 2003 version so i'm really stuck]. I made a
mail merge of approximately 100 titles and added graphics etc. But,
when I went to preview I got a shocl: I get over 390 labels due to
constant duplications! They're supposed to be in alphabetical
order,
yet they keep jumping back and restarting at different points. How
can I correct this problem?








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.