View Single Post
  #8   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

This web site? This is a peer group help forum. The link I posted earlier
explains the complete process with pictures.

For a single label, merge just the one record in question or merge a range
of records to a new document and delete the labels contents you don't
require.

--

Graham Mayor - Word MVP

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



Munchichic wrote:
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!