Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2006

Tip: Looking for answers? Try searching our database.

WP labels to Word Mail Merge?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tracey - 13 Jul 2006 15:19 GMT
is there a way? I have several lists of labels that I want to put into a Word
merge document/db. Is it possible? I'm hoping not to have to retype them all
but i think i'm going to have to.   I've done a save as to a text file and it
will come up in Word but not sure if or how to make it into a merge db.

thanks
Tracey

We have Corel 8 and Office 2003
Charles Kenyon - 13 Jul 2006 15:38 GMT
Check Graham Mayor's Word Tips. http://gmayor.com He has an article on how
to do this.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> is there a way? I have several lists of labels that I want to put into a
> Word
[quoted text clipped - 8 lines]
>
> We have Corel 8 and Office 2003
Peter Jamieson - 13 Jul 2006 15:43 GMT
If you have saved what is essentially a printed version of your addresses
(or whatever they are) then I suggest you look at Graham Mayor's article at:

http://www.gmayor.com/convert_labels_into_mail_merge.htm

However, if you still have WP on your system, Word can use data in a number
of formats as the data source for a merge (if that is what you want to do),
and can also read older WP document formats.

In essence, Word expects a data source to be a simple table with column
labels on the first row. That table can be a simple comma- or tab-delimited
text file, a comma- or tab-delimited Word document, an Excel sheet, a table
in an Access database, and so on.

If your label data contains addresses, then the simplest way to keep the
data for future use is probably to create a table in a Word document with
one column with "Address" in the top cell and one address per cell. You may
be able to create that by creating such a table from your data in WP, and
either
a. saving it as a WP file then opening it in Word
b. exporting it as a Word or .rtf file (I do not know which is possible)

If your label data contains addresses with structural information (e.g. if
the address is explicitly split up into street name, city, country, etc.)
then you may want to try to create a data source with one column for each
part of the address (i.e. Street, City, whatever). In that case, try to
create a document contianing a table with one column for each address item,
and export that to .doc/.rtf etc. There are advantages and disadvantages to
each approach.

Peter Jamieson

> is there a way? I have several lists of labels that I want to put into a
> Word
[quoted text clipped - 8 lines]
>
> We have Corel 8 and Office 2003
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.