#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing Single Labels | dazwm | Mail Merge | 3 | 02-25-2014 01:23 AM |
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 |
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 |