Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Changing name/address in Excel row to Word address block format
Hello,
I have a row in Excel where each cell has a first name, last name, address, city, state and zip code. I don't need to copy all of the cells in this row; just the cells I listed above. I want to be able to copy those cells, paste it in Word and format it so it looks like an address block at the beginning of a letter, ex: John Smith 123 Apple St. St. Louis, MO 98765 These different address blocks will be added to letters that already exist. I just have to add the address blocks to them. I tried pasting the cells from Excel to Word, converting table to text, then replacing the tab markers to paragraph markers but the paragraph marks didn't shift my address underneath my names or my city/state/zips under my addresses. Please help. I have hundreds of letters to do and don't relish having to manually add the address info in Excel to these different letters in Word. Thank you!! Studebaker |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Changing name/address in Excel row to Word address block format
Hi Studebaker,
Perhaps a mailmerge is what you're after. The Word mailmerge process allows you to choose which fields (columns) from you Excel workbook to insert into your document, and where. When you execute the merge, all the letters will be produced for you. -- Cheers macropod [Microsoft MVP - Word] "Studebaker" wrote in message ... Hello, I have a row in Excel where each cell has a first name, last name, address, city, state and zip code. I don't need to copy all of the cells in this row; just the cells I listed above. I want to be able to copy those cells, paste it in Word and format it so it looks like an address block at the beginning of a letter, ex: John Smith 123 Apple St. St. Louis, MO 98765 These different address blocks will be added to letters that already exist. I just have to add the address blocks to them. I tried pasting the cells from Excel to Word, converting table to text, then replacing the tab markers to paragraph markers but the paragraph marks didn't shift my address underneath my names or my city/state/zips under my addresses. Please help. I have hundreds of letters to do and don't relish having to manually add the address info in Excel to these different letters in Word. Thank you!! Studebaker |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Changing name/address in Excel row to Word address block format
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm and insert the fields you require in the layout you want. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Studebaker wrote: Hello, I have a row in Excel where each cell has a first name, last name, address, city, state and zip code. I don't need to copy all of the cells in this row; just the cells I listed above. I want to be able to copy those cells, paste it in Word and format it so it looks like an address block at the beginning of a letter, ex: John Smith 123 Apple St. St. Louis, MO 98765 These different address blocks will be added to letters that already exist. I just have to add the address blocks to them. I tried pasting the cells from Excel to Word, converting table to text, then replacing the tab markers to paragraph markers but the paragraph marks didn't shift my address underneath my names or my city/state/zips under my addresses. Please help. I have hundreds of letters to do and don't relish having to manually add the address info in Excel to these different letters in Word. Thank you!! Studebaker |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Changing name/address in Excel row to Word address block forma
I appreciate both of your replies. I don't know if mail merge will
necessarily work be efficient in this instance b/c I'll have to set up fields for each of my letters already made. I will keep in mind your first link, though. Thank you. Studebaker "Graham Mayor" wrote: See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or http://www.gmayor.com/merge_labels_with_word_2007.htm and insert the fields you require in the layout you want. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Studebaker wrote: Hello, I have a row in Excel where each cell has a first name, last name, address, city, state and zip code. I don't need to copy all of the cells in this row; just the cells I listed above. I want to be able to copy those cells, paste it in Word and format it so it looks like an address block at the beginning of a letter, ex: John Smith 123 Apple St. St. Louis, MO 98765 These different address blocks will be added to letters that already exist. I just have to add the address blocks to them. I tried pasting the cells from Excel to Word, converting table to text, then replacing the tab markers to paragraph markers but the paragraph marks didn't shift my address underneath my names or my city/state/zips under my addresses. Please help. I have hundreds of letters to do and don't relish having to manually add the address info in Excel to these different letters in Word. Thank you!! Studebaker |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Changing name/address in Excel row to Word address block format
I agree with macropod and Graham that a mail merge is what is needed, at
least if you are producing multiple letters at one time. See http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and http://word.mvps.org/FAQs/MailMerge/...ataSource.htm; from the latter you will see that what you have in Excel is already a perfectly satisfactory data source. You can insert merge fields in the desired order, separating lines with line breaks, then complete the merge. The letter you have already written can easily be used as the mail merge main document. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Studebaker" wrote in message ... Hello, I have a row in Excel where each cell has a first name, last name, address, city, state and zip code. I don't need to copy all of the cells in this row; just the cells I listed above. I want to be able to copy those cells, paste it in Word and format it so it looks like an address block at the beginning of a letter, ex: John Smith 123 Apple St. St. Louis, MO 98765 These different address blocks will be added to letters that already exist. I just have to add the address blocks to them. I tried pasting the cells from Excel to Word, converting table to text, then replacing the tab markers to paragraph markers but the paragraph marks didn't shift my address underneath my names or my city/state/zips under my addresses. Please help. I have hundreds of letters to do and don't relish having to manually add the address info in Excel to these different letters in Word. Thank you!! Studebaker |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge address block name format is wrong | Mailmerge | |||
format outlook address block not part of merged document | Microsoft Word Help | |||
Address block does not line name and address up on envelopes | Mailmerge | |||
WORD 2003 - change 'address block' format | Mailmerge | |||
Mail Merge Address Block Missing Address 3 | Mailmerge |