View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Address labels from Excel Database

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Wadda wrote:
This is awful. I completely forgot my excel and cannot find my notes.
I would set up worksheet for friends to automate address labels. I
would have a DB file in Excel, write concatenate formulas and load
the data from across the spreadsheet to Address label format. Then
export to data to a Word document to print out on Avery address
labels. I cannot get the data to transpose to address label format in
Excel. The data transposes to label format but it spreads across the
spreadsheet through the columns instead of from top of the page down
in columns. Completely drawing a blank. Where can I go to refresh my
memory. Thank you in advance for your assistance.

Wadda