Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge & Excel
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 |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge & Excel
What version of Word?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "TX Jo" wrote in message ... 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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge & Excel
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_lab...th_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" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Word Mail Merge from Excel -- Force Excel to open the datafile? | Mailmerge | |||
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 | Mailmerge | |||
mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
How to convert a mail merge document back to excel after mail mer | Microsoft Word Help | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help |