Reply
 
Thread Tools Display Modes
  #1   Report Post  
keg
 
Posts: n/a
Default can a mail merge be done from existing labels?


  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

You don't say much about what you are starting with, but Graham Mayor's
article at

http://www.gmayor.com/convert_labels...mail_merge.htm

may be relevant.

Peter Jamieson
"keg" wrote in message
...



  #3   Report Post  
chipp2shore chipp2shore is offline
Junior Member
 
Location: St Pete, Florida
Posts: 9
Default

1) If the labels have been printed out, they can be scanned into Word using OCR. If you then place them one above the other with a space in between each address block, you can use the formula described in the MS support article using Method 1.

http://support.microsoft.com/kb/212335

2) If the labels have been saved in Word, you can use the 'convert table to text' and make a new list of addresses (in one column) put the word ADDRESS above the first address then a space before your first address block. This is your header. Make sure there is only one space between each address block. Now you are ready to make a table. First do a search and replace for Enter/ Paragraph marks and replace them all with manual line breaks. Then do a search and replace for 2 manual line breaks ^l^l and replace these with one paragraph mark ^p. This will give you a Paragragh/Enter mark as a delimiter between each address record. Using 'Convert Text to Table' you will now have your addresses in a table. Now name and save this file, and you are ready to make new labels using mail merge from this table.

Hope this helps!
Chris


Last edited by chipp2shore : March 8th 12 at 04:05 PM Reason: clarification
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 Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
30 page mail merge labels only prints one page? bdhamer Mailmerge 2 October 13th 05 05:07 AM
Creating mailing labels with the Mail Merge Helper Stephen White New Users 1 April 5th 05 02:25 PM
Word Labels into Mail Merge Labels GG Katie Mailmerge 1 January 24th 05 11:12 PM
Why can't I use Mail Merge Wizard with Avery 2160 labels?. Andy39 Mailmerge 1 December 10th 04 02:19 AM


All times are GMT +1. The time now is 05:56 PM.

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"