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 / January 2008

Tip: Looking for answers? Try searching our database.

How do I open an Office Address list without Access?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
APCJr - 27 Jan 2008 18:31 GMT
I've created a Microsoft Address Word Address List via the Word 2003
MailMerge/Label function.  I tried to open the Address List independent of
Word, but was unsuccessful.  I do not have Access on that PC.  Is there a way
to simply open and edit the Adress Lst, independently, without havong to go
theough Word?
Doug Robbins - Word MVP - 29 Jan 2008 02:00 GMT
Use the address list as the data source for a Directory type mail merge in
the main document of which, you have a single row table with as many cells
as there are fields in the data source.  When you execute that merge to a
new document, that document will have a row of data for each record in the
data source.  Insert a row at the top of the table and into the cells in
that row, enter the names of the merge fields.  Then save that document and
use it as your data source, editing it as required.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I've created a Microsoft Address Word Address List via the Word 2003
> MailMerge/Label function.  I tried to open the Address List independent of
[quoted text clipped - 3 lines]
> go
> theough Word?
Peter Jamieson - 30 Jan 2008 17:47 GMT
You can open an OAL in Excel if you have that product.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> I've created a Microsoft Address Word Address List via the Word 2003
> MailMerge/Label function.  I tried to open the Address List independent of
[quoted text clipped - 3 lines]
> go
> theough Word?
Peter Jamieson - 30 Jan 2008 17:50 GMT
But I don't think you will be able to edit it /and/ save it as an OAL again.
But you should be able to save it as a .xls and use that thereafter.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> You can open an OAL in Excel if you have that product.
>
[quoted text clipped - 6 lines]
>> go
>> theough Word?
 
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.