pulling addresses into word from excel

bdee1

Board Regular
Joined
Feb 17, 2003
Messages
105
i work in a hospital where our medical transcriptionists use word to generate envelopes. they go to tools, Letters and Mailings, Envelopes and Labels. then in that dialog there is an icon that gives them access to their outlook contacts. they choose a name and the Address field is populated in Word so they can print the envelope.

problem is that we are migrating to a new mail client and they will no longer have outlook. so we were thinking we could export their contacts from outlook to an excel (csv) file. but the problem is, how could we point that address book button in word - to the excel file

is this something that needs to be scripted in some way? or is there a simple solution. any advice would be appreciated.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,225,327
Messages
6,184,301
Members
453,227
Latest member
Slainte

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top