how do I use an excel spreadsheet for labels with a Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Theresa - 24 Apr 2007 21:50 GMT

I am currently trying to do a mass mailing, and all my addresses are in my
excel spreadsheet. When I use Word to do the mail merge for the labels, I get
next record. I am having a bit of a brain freeze, its been a while since I
did this! I can't remember how I did it last time, and I am seriously stuck!
Can anyone help me. I know I can take all my addresses in Excel and have the
labels merged and I had very little correcting. I am also now using MS
Office 2007. (Kinda new to this version)

Signature

Thanks for any help
Theresa

Reply to this Message

Peter Jamieson - 24 Apr 2007 23:35 GMT

Sorry, I couldn't quite make sense of your message at this point:

> When I use Word to do the mail merge for the labels, I get
> next record.

But some common problems are:
a. you haven't inserted any fields in cell 1 of your label layout (Word
doesn't try to guess what you want). You won't see any output.
b. you haven't done the "propagate labels" step (which copies your layout
from cell 1 to all the other cells). You'll just get one label per page.
c. you have put a <<Next record>> field (a { NEXT } field in every cell
including the first one. You'll skip one record every page because you
should not have a { NEXT } in cell 1
d. you are merely previewing the merge instead of either printing it or
merging to a new document.

Peter Jamieson

>I am currently trying to do a mass mailing, and all my addresses are in my
> excel spreadsheet. When I use Word to do the mail merge for the labels, I
[quoted text clipped - 6 lines]
> labels merged and I had very little correcting. I am also now using MS
> Office 2007. (Kinda new to this version)

Reply to this Message