Mail Merge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bmorganh - 30 Oct 2007 19:54 GMT

I have tried to follow the help file to merge a list of names from Excel into
Labels in Word. When I get to the step that allows me to preview the merge
it is always blank. Also when I print the labels they are blank. Help!

Reply to this Message

Peter Jamieson - 01 Nov 2007 09:25 GMT

You have to insert some mailmerge fields from your Excel workbook into the
label document - Word does not do this automatically (it cannot know which
data you want to insert). See for example Graham Mayor's pages at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
or
http://www.gmayor.com/merge_labels_with_word_2007.htm

Peter Jamieson

>I have tried to follow the help file to merge a list of names from Excel
>into
> Labels in Word. When I get to the step that allows me to preview the
> merge
> it is always blank. Also when I print the labels they are blank. Help!

Reply to this Message

Mike - 03 Nov 2007 23:28 GMT

In message <uyCh4CGHIHA.1208@TK2MSFTNGP03.phx.gbl>
at 08:25:10 on Thu, 1 Nov 2007, Peter Jamieson
<pjj@KillmapSpjjnet.demon.co.uk> wrote

>You have to insert some mailmerge fields from your Excel workbook into the
>label document - Word does not do this automatically (it cannot know which
[quoted text clipped - 3 lines]
>or
>http://www.gmayor.com/merge_labels_with_word_2007.htm

For the life of me I could not find the "Insert Merge Fields" button
when going from 2000 (where the button was labelled with those words) to
2003, but I have it now. The Office 2003 page is slightly different as
it's more wizard like, but the above made me think a bit more to look
for the button, so thanks for your post.

Signature

Mike News

Reply to this Message

Peter Jamieson - 04 Nov 2007 00:51 GMT

In Word 2002/2003 it's often easier to enable the MailMerge toolbar (e.g. in
View|Toolbars) than to use the wizard. It doesn't appear/disappear
automatically like the one in Word 2000 and earlier though...

Peter Jamieson

> In message <uyCh4CGHIHA.1208@TK2MSFTNGP03.phx.gbl>
> at 08:25:10 on Thu, 1 Nov 2007, Peter Jamieson
[quoted text clipped - 12 lines]
> more wizard like, but the above made me think a bit more to look for the
> button, so thanks for your post.

Reply to this Message

Mike - 04 Nov 2007 16:24 GMT

In message <eb#wzRnHIHA.280@TK2MSFTNGP03.phx.gbl>
at 23:51:26 on Sat, 3 Nov 2007, Peter Jamieson
<pjj@KillmapSpjjnet.demon.co.uk> wrote

>In Word 2002/2003 it's often easier to enable the MailMerge toolbar (e.g. in
>View|Toolbars) than to use the wizard. It doesn't appear/disappear
>automatically like the one in Word 2000 and earlier though...

I had done that, but spotting the icon which used to be a text label had
me foxed for ages.

Signature

Mike News

Reply to this Message