I can't make it do mail merge!

[Guest]

Hi,
I am using Windows XP Professional and have Excel 2002. I am trying to do a mial merge at my office, but it is COMPLETELY different from the setup on my Windows XP Professional PC at home. Basically, it wants me to select address blocks (rather than fields). It will let me insert fields, but I have to close the insert window after each insert, then hit enter to get to the next line, then do the next insert, etc. Very labor intensive. After all this, somehow I ended up with 4 indentical letters (and I have 4 very different addresses in my Excel spreadsheet). I have never seen such a mess!
Is this something I am doing wrong, or does it sound like I have a buggy machine (it's brand new and doing other weird things, imo).

Thanks,
Kelly

 

[JulieD]

Hi Kelly

one of the secrets to using mail merge in Word 2002 (other than using Word
2000 instead) is to add the INSERT MERGE FIELD icon on to your Mail Merge
toolbar and use that to insert your fields.

To do this, choose View / Toolbars and display the Mail Merge toolbar by
clicking on it, then choose View / Toolbars and Customize, from the Commands
tab, choose the Mail Merge category and then drag Insert Merge Field onto
the toolbar.

Now you can click on this and see all your fields.

This might solve your other problem as well - if not, post back

Hope this helps
JulieD

Hi,
I am using Windows XP Professional and have Excel 2002. I am trying to do

a mial merge at my office, but it is COMPLETELY different from the setup on
my Windows XP Professional PC at home. Basically, it wants me to select
address blocks (rather than fields). It will let me insert fields, but I
have to close the insert window after each insert, then hit enter to get to
the next line, then do the next insert, etc. Very labor intensive. After all
this, somehow I ended up with 4 indentical letters (and I have 4 very
different addresses in my Excel spreadsheet). I have never seen such a mess!

Is this something I am doing wrong, or does it sound like I have a buggy

machine (it's brand new and doing other weird things, imo).

 

[Guest]

Hi Julie
Thanks - I do have th tool bar showing, and it does the same weird things even if I use it.

Kell


----- JulieD wrote: ----

Hi Kell

one of the secrets to using mail merge in Word 2002 (other than using Wor
2000 instead) is to add the INSERT MERGE FIELD icon on to your Mail Merg
toolbar and use that to insert your fields

To do this, choose View / Toolbars and display the Mail Merge toolbar b
clicking on it, then choose View / Toolbars and Customize, from the Command
tab, choose the Mail Merge category and then drag Insert Merge Field ont
the toolbar

Now you can click on this and see all your fields

This might solve your other problem as well - if not, post bac

Hope this help
Julie

Hi
I am using Windows XP Professional and have Excel 2002. I am trying to d

a mial merge at my office, but it is COMPLETELY different from the setup o
my Windows XP Professional PC at home. Basically, it wants me to selec
address blocks (rather than fields). It will let me insert fields, but
have to close the insert window after each insert, then hit enter to get t
the next line, then do the next insert, etc. Very labor intensive. After al
this, somehow I ended up with 4 indentical letters (and I have 4 ver
different addresses in my Excel spreadsheet). I have never seen such a mess

Is this something I am doing wrong, or does it sound like I have a bugg

machine (it's brand new and doing other weird things, imo)