Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Wadda Wadda is offline
external usenet poster
 
Posts: 1
Default Address labels from Excel Database

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



Reply
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 and Excel data to print Labels G.Wee Mailmerge 1 August 22nd 06 12:46 PM
Creating address labels with mailmerge [email protected] Mailmerge 2 March 22nd 06 07:13 PM
multiple address labels using excel file Punaboy Mailmerge 1 March 1st 06 07:27 AM
Merging labels from excel starts second page with second record Debbie Mailmerge 1 February 8th 06 07:17 PM
Importing an excel document (address list) to a Word address book Sherry Lee Mailmerge 3 August 19th 05 01:17 AM


All times are GMT +1. The time now is 04:32 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"