Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Munchichic Munchichic is offline
external usenet poster
 
Posts: 8
Default Word 2007 mail merge using Excel 2007 data

Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I
created an address database in Excel to use in a Word mail merge for mailing
labels. After several attempts I finally got the data to merge (the normal
DDE method didn't work as it said there was no data).

There are only 19 labels in the merge. They only show in Preview using the
very top left label field; I can scroll through all of the 19 records and
they all appear in the same spot. If I print the mail merge only one label
prints in that very same spot. I need ALL of the labels to be on the same
document. What am I doing wrong?

Once I succeed in having all of the labels on the same page is it possible
to only select one, or speciifc, label(s) to print without deleting the rest
on the sheet? Any help is greatly appreciated. This is a project at work
where data is on a network drive if that helps. Thank you and I hope you all
have a great weekend!
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Word 2007 mail merge using Excel 2007 data

Hi Munchichic,

Your problem description suggests you didn't choose the 'labels' merge option.

--
Cheers
macropod
[Microsoft MVP - Word]


"Munchichic" wrote in message ...
Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I
created an address database in Excel to use in a Word mail merge for mailing
labels. After several attempts I finally got the data to merge (the normal
DDE method didn't work as it said there was no data).

There are only 19 labels in the merge. They only show in Preview using the
very top left label field; I can scroll through all of the 19 records and
they all appear in the same spot. If I print the mail merge only one label
prints in that very same spot. I need ALL of the labels to be on the same
document. What am I doing wrong?

Once I succeed in having all of the labels on the same page is it possible
to only select one, or speciifc, label(s) to print without deleting the rest
on the sheet? Any help is greatly appreciated. This is a project at work
where data is on a network drive if that helps. Thank you and I hope you all
have a great weekend!

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Munchichic Munchichic is offline
external usenet poster
 
Posts: 8
Default Word 2007 mail merge using Excel 2007 data

Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm
very new to Office 2007 and haven't used mail merges too much in the past.
What exactly do I need to do? Thank you!

"macropod" wrote:

Hi Munchichic,

Your problem description suggests you didn't choose the 'labels' merge option.

--
Cheers
macropod
[Microsoft MVP - Word]


"Munchichic" wrote in message ...
Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I
created an address database in Excel to use in a Word mail merge for mailing
labels. After several attempts I finally got the data to merge (the normal
DDE method didn't work as it said there was no data).

There are only 19 labels in the merge. They only show in Preview using the
very top left label field; I can scroll through all of the 19 records and
they all appear in the same spot. If I print the mail merge only one label
prints in that very same spot. I need ALL of the labels to be on the same
document. What am I doing wrong?

Once I succeed in having all of the labels on the same page is it possible
to only select one, or speciifc, label(s) to print without deleting the rest
on the sheet? Any help is greatly appreciated. This is a project at work
where data is on a network drive if that helps. Thank you and I hope you all
have a great weekend!


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Munchichic Munchichic is offline
external usenet poster
 
Posts: 8
Default Word 2007 mail merge using Excel 2007 data

I'm sorry. I forgot to mention that the merge did appear in the label format
showing the gridlines and all. The label settings were correct but only Row
1, Column 1 was being used for each address label. 19 addresses = 19 pages of
labels since only one label per sheet was being used. I don't understand what
I did wrong. Thanks again!

"Munchichic" wrote:

Thanks for the reply. I'm sorry but I don't understand your suggestion. I'm
very new to Office 2007 and haven't used mail merges too much in the past.
What exactly do I need to do? Thank you!

"macropod" wrote:

Hi Munchichic,

Your problem description suggests you didn't choose the 'labels' merge option.

--
Cheers
macropod
[Microsoft MVP - Word]


"Munchichic" wrote in message ...
Hi Everyone. I'm new to Office 2007 and I can't figure out this problem. I
created an address database in Excel to use in a Word mail merge for mailing
labels. After several attempts I finally got the data to merge (the normal
DDE method didn't work as it said there was no data).

There are only 19 labels in the merge. They only show in Preview using the
very top left label field; I can scroll through all of the 19 records and
they all appear in the same spot. If I print the mail merge only one label
prints in that very same spot. I need ALL of the labels to be on the same
document. What am I doing wrong?

Once I succeed in having all of the labels on the same page is it possible
to only select one, or speciifc, label(s) to print without deleting the rest
on the sheet? Any help is greatly appreciated. This is a project at work
where data is on a network drive if that helps. Thank you and I hope you all
have a great weekend!


  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Word 2007 mail merge using Excel 2007 data

It sounds as though you are merely previewing the merge rather than
coimpleting it - see http://www.gmayor.com/merge_labels_with_word_2007.htm

--

Graham Mayor - Word MVP

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



Munchichic wrote:
I'm sorry. I forgot to mention that the merge did appear in the label
format showing the gridlines and all. The label settings were correct
but only Row 1, Column 1 was being used for each address label. 19
addresses = 19 pages of labels since only one label per sheet was
being used. I don't understand what I did wrong. Thanks again!

"Munchichic" wrote:

Thanks for the reply. I'm sorry but I don't understand your
suggestion. I'm very new to Office 2007 and haven't used mail merges
too much in the past. What exactly do I need to do? Thank you!

"macropod" wrote:

Hi Munchichic,

Your problem description suggests you didn't choose the 'labels'
merge option.

--
Cheers
macropod
[Microsoft MVP - Word]


"Munchichic" wrote in
message ...
Hi Everyone. I'm new to Office 2007 and I can't figure out this
problem. I created an address database in Excel to use in a Word
mail merge for mailing labels. After several attempts I finally
got the data to merge (the normal DDE method didn't work as it
said there was no data).

There are only 19 labels in the merge. They only show in Preview
using the very top left label field; I can scroll through all of
the 19 records and they all appear in the same spot. If I print
the mail merge only one label prints in that very same spot. I
need ALL of the labels to be on the same document. What am I doing
wrong?

Once I succeed in having all of the labels on the same page is it
possible to only select one, or speciifc, label(s) to print
without deleting the rest on the sheet? Any help is greatly
appreciated. This is a project at work where data is on a network
drive if that helps. Thank you and I hope you all have a great
weekend!





  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Word 2007 mail merge using Excel 2007 data

In the mail merge main document, you need to use the Update Labels button
under the Write & Insert Fields section of the Mailings tab of the Ribbon to
replicate the setup from the first label on the sheet to all of the other
labels on the sheet.

--
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, originally posted via msnews.microsoft.com
"Munchichic" wrote in message
...
I'm sorry. I forgot to mention that the merge did appear in the label
format
showing the gridlines and all. The label settings were correct but only
Row
1, Column 1 was being used for each address label. 19 addresses = 19 pages
of
labels since only one label per sheet was being used. I don't understand
what
I did wrong. Thanks again!

"Munchichic" wrote:

Thanks for the reply. I'm sorry but I don't understand your suggestion.
I'm
very new to Office 2007 and haven't used mail merges too much in the
past.
What exactly do I need to do? Thank you!

"macropod" wrote:

Hi Munchichic,

Your problem description suggests you didn't choose the 'labels' merge
option.

--
Cheers
macropod
[Microsoft MVP - Word]


"Munchichic" wrote in message
...
Hi Everyone. I'm new to Office 2007 and I can't figure out this
problem. I
created an address database in Excel to use in a Word mail merge for
mailing
labels. After several attempts I finally got the data to merge (the
normal
DDE method didn't work as it said there was no data).

There are only 19 labels in the merge. They only show in Preview
using the
very top left label field; I can scroll through all of the 19 records
and
they all appear in the same spot. If I print the mail merge only one
label
prints in that very same spot. I need ALL of the labels to be on the
same
document. What am I doing wrong?

Once I succeed in having all of the labels on the same page is it
possible
to only select one, or speciifc, label(s) to print without deleting
the rest
on the sheet? Any help is greatly appreciated. This is a project at
work
where data is on a network drive if that helps. Thank you and I hope
you all
have a great weekend!


  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Munchichic Munchichic is offline
external usenet poster
 
Posts: 8
Default Word 2007 mail merge using Excel 2007 data

Thanks for the responses. I got the instructions for this mail merge directly
from this website. They make no mention of propagating anything. The final
step was to select the finish and merge button and print the labels. Using
the Update Field option I was finally able to see all of the labels on one
sheet. So the last explanation I got from Doug Robbins was very helpful. My
only question at this point is whether or not there is a way to only print
one specific label from a mail merge, or if you're forced to printint out the
entire listing. Thanks for the help with this!

"Doug Robbins - Word MVP" wrote:

In the mail merge main document, you need to use the Update Labels button
under the Write & Insert Fields section of the Mailings tab of the Ribbon to
replicate the setup from the first label on the sheet to all of the other
labels on the sheet.

--
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, originally posted via msnews.microsoft.com
"Munchichic" wrote in message
...
I'm sorry. I forgot to mention that the merge did appear in the label
format
showing the gridlines and all. The label settings were correct but only
Row
1, Column 1 was being used for each address label. 19 addresses = 19 pages
of
labels since only one label per sheet was being used. I don't understand
what
I did wrong. Thanks again!

"Munchichic" wrote:

Thanks for the reply. I'm sorry but I don't understand your suggestion.
I'm
very new to Office 2007 and haven't used mail merges too much in the
past.
What exactly do I need to do? Thank you!

"macropod" wrote:

Hi Munchichic,

Your problem description suggests you didn't choose the 'labels' merge
option.

--
Cheers
macropod
[Microsoft MVP - Word]


"Munchichic" wrote in message
...
Hi Everyone. I'm new to Office 2007 and I can't figure out this
problem. I
created an address database in Excel to use in a Word mail merge for
mailing
labels. After several attempts I finally got the data to merge (the
normal
DDE method didn't work as it said there was no data).

There are only 19 labels in the merge. They only show in Preview
using the
very top left label field; I can scroll through all of the 19 records
and
they all appear in the same spot. If I print the mail merge only one
label
prints in that very same spot. I need ALL of the labels to be on the
same
document. What am I doing wrong?

Once I succeed in having all of the labels on the same page is it
possible
to only select one, or speciifc, label(s) to print without deleting
the rest
on the sheet? Any help is greatly appreciated. This is a project at
work
where data is on a network drive if that helps. Thank you and I hope
you all
have a great weekend!



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Excel 2007 cell data into word 2007 fields? Tec92407 Microsoft Word Help 1 July 25th 09 07:58 AM
Word 2007 Mail Merge Data scarrigan Mailmerge 2 February 13th 09 07:41 AM
Mail Merge Labels (Word 2007) w/ Excel (2007) aedcone Microsoft Word Help 2 August 11th 08 03:14 PM
Mail Merge Labels (Word 2007) from Excel (2007) aedcone Microsoft Word Help 3 August 8th 08 03:29 PM
Word 2007 Mail Merge through Excel rcaquest Mailmerge 0 October 12th 07 02:08 AM


All times are GMT +1. The time now is 09:51 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"