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