View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Marcdavid62 Marcdavid62 is offline
external usenet poster
 
Posts: 3
Default How do I make an address label in excel, then merge it with Wo

Have you ever seen the text look like this, Mike Johnson||123 harvard
st||cleveland OH. the "||" somehow inserts the next few words right below,
making it look like an address on an envelope. Do you know how to do this?

"Dave Peterson" wrote:

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

Marcdavid62 wrote:

i want to type an address in one cell, for instance, Mr Marc johnson 123
ardmore canton ohio 11111. When this merges with Word i want the label to
show the name address and city on 3 separate lines. how do I do this?


--

Dave Peterson