Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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) -- Thanks for any help Theresa |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 a 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 "Theresa" wrote in message ... 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) -- Thanks for any help Theresa |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert an excel spreadsheet to mail merge in word? | Microsoft Word Help | |||
Mail Merge will not allow me to get Excel spreadsheet addresses | Mailmerge | |||
How do I get mail merge address list into Excel spreadsheet? | Mailmerge | |||
Mail Merge using an Excel spreadsheet as a data source | Microsoft Word Help | |||
Mail Merge labels from Excel spreadsheet of addresses | Mailmerge |