Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
APCJr APCJr is offline
external usenet poster
 
Posts: 1
Default How do I open an Office Address list without Access?

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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I open an Office Address list without Access?

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.

--
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

"APCJr" wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How do I open an Office Address list without Access?

You can open an OAL in Excel if you have that product.

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

"APCJr" wrote in message
...
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?


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How do I open an Office Address list without Access?

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.

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

"Peter Jamieson" wrote in message
...
You can open an OAL in Excel if you have that product.

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

"APCJr" wrote in message
...
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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
making address labels from word address list ME Mailmerge 2 February 7th 12 08:16 PM
How do I Create and address list for envelope delivery address Michelle Microsoft Word Help 0 June 8th 06 07:35 PM
Importing an excel document (address list) to a Word address book Sherry Lee Mailmerge 3 August 19th 05 01:17 AM
mail merged in word w/ address list in excel, now cant open excel MAIL MERGE from Excel Mailmerge 3 May 9th 05 05:31 PM
word mail merge---address list saved as access mdb Carol Mailmerge 2 February 8th 05 11:50 PM


All times are GMT +1. The time now is 09:16 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"