Group:  Microsoft Word ยป microsoft.public.word.docmanagement
Thread: Mail Merge & Excel

Geek News

Mail Merge & Excel
TX Jo 12/23/2008 1:51:00 AM
I have an excel spreadsheet with several columns of info. Name (Current
Resident), Address1 (Street #), Address 2 (Condo #), Address 3 (Street Name),
City, State, Zip are the column headings. The parenthesis are what the info
is and not included in the column heading.

I need to do a mail merge. Although I have used excel and word for years, I
am a mail merge newbie, so need help in figuring out how to do this. I have
tried, and can't get past arranging the labels and creating the address block
using the fields that are provided. Any help you can give would be greatly
appreciated!

Thanks so much
--
TX Jo
Re: Mail Merge & Excel
"Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> 12/23/2008 4:16:28 AM
What version of Word?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"TX Jo" <TXJo[ at ]discussions.microsoft.com> wrote in message
news:8FDDCFC6-C41E-4455-B114-3D93E602470E[ at ]microsoft.com...
[Quoted Text]
>I have an excel spreadsheet with several columns of info. Name (Current
> Resident), Address1 (Street #), Address 2 (Condo #), Address 3 (Street
> Name),
> City, State, Zip are the column headings. The parenthesis are what the
> info
> is and not included in the column heading.
>
> I need to do a mail merge. Although I have used excel and word for years,
> I
> am a mail merge newbie, so need help in figuring out how to do this. I
> have
> tried, and can't get past arranging the labels and creating the address
> block
> using the fields that are provided. Any help you can give would be
> greatly
> appreciated!
>
> Thanks so much
> --
> TX Jo


Re: Mail Merge & Excel
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/23/2008 4:16:46 AM
Don't use the Address Block. Just insert the merge fields that you want to
use in the configuration that you want them.

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

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

See the article "Mail Merge with Word 2007" on fellow MVP Graham Mayor's
website at

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


--
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

"TX Jo" <TXJo[ at ]discussions.microsoft.com> wrote in message
news:8FDDCFC6-C41E-4455-B114-3D93E602470E[ at ]microsoft.com...
[Quoted Text]
>I have an excel spreadsheet with several columns of info. Name (Current
> Resident), Address1 (Street #), Address 2 (Condo #), Address 3 (Street
> Name),
> City, State, Zip are the column headings. The parenthesis are what the
> info
> is and not included in the column heading.
>
> I need to do a mail merge. Although I have used excel and word for years,
> I
> am a mail merge newbie, so need help in figuring out how to do this. I
> have
> tried, and can't get past arranging the labels and creating the address
> block
> using the fields that are provided. Any help you can give would be
> greatly
> appreciated!
>
> Thanks so much
> --
> TX Jo


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net