Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]() "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
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
Linking Access database to Microsoft Word form | Microsoft Word Help | |||
microsoft word for free | Microsoft Word Help | |||
you must log onto microsoft exchange to access address book | Microsoft Word Help | |||
include in visio icons for standard microsoft apps | Microsoft Word Help | |||
exporting accress reports into word | Microsoft Word Help |