 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Printing and Fonts / December 2004mail merge no list
My sister is working at a school for disabled children. She was asked to write a form letter using mail merge to include the names and addresses of the recipients at the head of the letter. She was presented with a word document which is just pages of labels, (30 to a page - about 200 names) with the names and addresses. The person who created this file typed the names directly into the labels, in other words there is no Excel list or Outlook address book available. Is there a way of using this file to create a list so we don't have to type in all the names and addresses again? I tried copying and pasting to Excel without much success. Thanks for any help on this subject. Copy and paste into Excel should work ... persevere with this, because it is usually the best method. Or, experiment along these lines (assuming each table cell current contains a name plus two or more lines of address) -- 1) Convert all paragraph marks in the document to tabs, so each cell contains [Name]tab[Address1]tab[Address2]... 2) Convert the table to text with paragraph marks as separators 3) Select and paste into Excel ... then names and address lines should now be organised into separate columns. > My sister is working at a school for disabled children. She was asked to > write a form letter using mail merge to include the names and addresses of [quoted text clipped - 6 lines] > tried copying and pasting to Excel without much success. > Thanks for any help on this subject. See http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm  SignatureSuzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. > My sister is working at a school for disabled children. She was asked to > write a form letter using mail merge to include the names and addresses of [quoted text clipped - 6 lines] > tried copying and pasting to Excel without much success. > Thanks for any help on this subject. This is great! Thanks so much. > See http://www.word.mvps.org/FAQs/MailMerge/ConvertAdrsToDatafile.htm > [quoted text clipped - 10 lines] >> tried copying and pasting to Excel without much success. >> Thanks for any help on this subject. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.