Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2014, 08:40 AM
genoMU69 genoMU69 is offline Need help making labels from Single Column Word file of addresses Mac OS X Need help making labels from Single Column Word file of addresses Office for Mac 2011
Novice
Need help making labels from Single Column Word file of addresses
 
Join Date: Jun 2011
Posts: 2
genoMU69 is on a distinguished road
Default Need help making labels from Single Column Word file of addresses

Hello All - I have never done this before and tutorials I have found online are not helping at all.

I have a word file set up as such



Name
Address
Address2
City, State, zip

Name
Address
Address2
City, State, zip

Hard returns in between address info. Two hard returns in between contacts.

I would appreciate ANY help.

Thank you in advance.


Gene
Reply With Quote
  #2  
Old 06-26-2014, 03:33 PM
macropod's Avatar
macropod macropod is offline Need help making labels from Single Column Word file of addresses Windows 7 32bit Need help making labels from Single Column Word file of addresses Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your data really aren't set up correctly for this. To prepare the data:
1. Use Find/Replace with -
Find = ^p
Replace = ^t
then -
Find = ^t^t
Replace = ^p
2. Select the whole lot and use Insert|Table>Convert Text to Table>OK to turn the data into a table.
3. Add a header row to the table, with Name, Address1, Address2, Address as the cell contents.
4. Save the document.
5. Create a new document and choose the label format you want via Mailings|Start Mailmerge>Labels.
6. Choose Select Recipients>Use Existing List and navigate to your document containing the labels.
7. In the first label, use Insert Mergefield to insert the Name, Address1, Address2, Address fields.
8. Arrange the label layout how you want it to appear.
9. Click 'Update labels'.
10. Save the mailmerge main document as a new file.
11. Click on Finish & Merge>Edit individual Documents>OK.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help making labels from Single Column Word file of addresses Printing Single Labels dazwm Mail Merge 3 02-25-2014 01:23 AM
Need help making labels from Single Column Word file of addresses Mail merge custom labels with double mention of addresses bng Mail Merge 6 05-30-2013 03:00 AM
Method to remove overlap in data labels for single series omahadivision Excel Programming 0 12-28-2012 08:55 PM
Need help making labels from Single Column Word file of addresses How to get mail merge to preview all addresses on labels rec Mail Merge 1 04-29-2011 10:32 PM
Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft