Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Mike
 
Posts: n/a
Default importing Microsoft Access Addresses

I would like to be able to select address that i have in a table in Access in
the address book in Word so that I can create addresses easily for envelopes
and documents. I do not want to mail merge mailing lables as most threads
have explained. If someone could give me an idea of how to go about this
(without coding). I'd appreciate it.

Thanks

Mike
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Kevin B
 
Posts: n/a
Default importing Microsoft Access Addresses

You can export the Access table or query to an Excel file and then insert the
excel file as an OLE object in word.

Once the Excel file is generated, move your cursor to the location in the
Word document where you want the addresses to be inserted.

Click INSERT in the menu and then select OBJECT. Click the CREATE FROM FILE
tab in the dialog box and then click the BROWSE button to locate the file.
If you click the LINK TO FILE check box the Word document will update
whenever the Excel file is updated or replaced.
--
Kevin Backmann


"Mike" wrote:

I would like to be able to select address that i have in a table in Access in
the address book in Word so that I can create addresses easily for envelopes
and documents. I do not want to mail merge mailing lables as most threads
have explained. If someone could give me an idea of how to go about this
(without coding). I'd appreciate it.

Thanks

Mike

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Mike
 
Posts: n/a
Default importing Microsoft Access Addresses



"Kevin B" wrote:

You can export the Access table or query to an Excel file and then insert the
excel file as an OLE object in word.

Once the Excel file is generated, move your cursor to the location in the
Word document where you want the addresses to be inserted.

Click INSERT in the menu and then select OBJECT. Click the CREATE FROM FILE
tab in the dialog box and then click the BROWSE button to locate the file.
If you click the LINK TO FILE check box the Word document will update
whenever the Excel file is updated or replaced.
--
Kevin Backmann


Thanks Kevin, but I'm just looking to see these addresses in the address book that is available in the toolbar or on the create envelope window.

  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor
 
Posts: n/a
Default importing Microsoft Access Addresses

This is not possible! You can only use a MAPI compliant address book -
essentially Outlook Contacts and have Outlook configured as your default
e-mail application.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Mike wrote:
"Kevin B" wrote:

You can export the Access table or query to an Excel file and then
insert the
excel file as an OLE object in word.

Once the Excel file is generated, move your cursor to the location
in the
Word document where you want the addresses to be inserted.

Click INSERT in the menu and then select OBJECT. Click the CREATE
FROM FILE
tab in the dialog box and then click the BROWSE button to locate the
file.
If you click the LINK TO FILE check box the Word document will update
whenever the Excel file is updated or replaced.
--
Kevin Backmann


Thanks Kevin, but I'm just looking to see these addresses in the
address book that is available in the toolbar or on the create
envelope window.



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
Linking Access database to Microsoft Word form Carrie B Microsoft Word Help 1 March 7th 06 09:22 PM
microsoft word for free aquina Microsoft Word Help 3 September 22nd 05 11:41 PM
you must log onto microsoft exchange to access address book Rick82 Microsoft Word Help 3 September 15th 05 06:28 PM
include in visio icons for standard microsoft apps Jonathan Stern Microsoft Word Help 1 May 20th 05 07:16 AM
exporting accress reports into word marc Microsoft Word Help 8 December 29th 04 04:40 PM


All times are GMT +1. The time now is 11:23 PM.

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

About Us

"It's about Microsoft Word"