Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2009, 10:08 PM
ClayShannon ClayShannon is offline Trying to merge label data from file Windows XP Trying to merge label data from file Office 2003
Novice
Trying to merge label data from file
 
Join Date: Sep 2009
Posts: 1
ClayShannon is on a distinguished road
Default Trying to merge label data from file


I need to import a bunch of addresses for Avery 5160 labels.

How can I get Word to take a file in the following format:

~Mr./Mrs. Peter Parker ;171 Perry Ln;Agawam;MA;01001;
~George C. Scott ;1433 S Park Ter;Agawam;MA;01001-2433;
~Thomas C. Pinchon ;22 Flat Hills Rd;Amherst;MA;01002;

...and treat the tilde (~) as a record delimiter, and semicolons ( as field
delimiters for this purpose?

I once saw a dialog in Word where I could specify what character to use
as the record and field delimiters, but cannot locate it now (have
tried "Tools | Letters and Mailings | Mail Merge" and "Tools | Letters
and Mailings | Envelopes and Labels)".
Reply With Quote
Reply

Tags
5160, address labels, field delimeters, mail merge, record delimiters



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help creating a data base for mail merge. acedking90 Mail Merge 0 07-27-2009 11:04 AM
Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM
Trying to merge label data from file How to open ppt file directly with slide show when clicked on file. praveen_p PowerPoint 1 05-06-2009 12:42 PM
Converting a Docx file to a Dictionary file geoffatmhg Word 0 02-08-2009 04:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 PM.


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