Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Studebaker Studebaker is offline
external usenet poster
 
Posts: 34
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge address block name format is wrong jewelb Mailmerge 3 April 4th 08 07:59 AM
format outlook address block not part of merged document ATKantor Microsoft Word Help 2 May 19th 07 06:12 AM
Address block does not line name and address up on envelopes IowaPack Mailmerge 1 June 27th 06 09:20 AM
WORD 2003 - change 'address block' format bjw007 Mailmerge 2 September 26th 05 11:50 PM
Mail Merge Address Block Missing Address 3 Joe Champagne Mailmerge 3 September 23rd 05 06:09 PM


All times are GMT +1. The time now is 08:26 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"