talytech
07-14-2009, 08:00 AM
Hi there. I have two questions.
1. Is there a way to check for an email address in the current user's outlook? For example. I have a button (btn1) .. when you click on it it promts the user to enter an email address in the input box. after entering the email, you click OK and at that point, I need for it to check and make sure the email address is found in the global address book in outlook. if it is found the run code to automatically send the Excel spreadsheet to the specified address. Is that possible?
If that isn't possible then next option .....
2. Is there a way to access the current user's global address book in outlook from Excel? For example. When the user clicks btn1 .. the address book is activated and the user can select the email address and then run code to automatically send the Excel spreadsheet to the specified address.
Any help is appreciated.
Thanks
1. Is there a way to check for an email address in the current user's outlook? For example. I have a button (btn1) .. when you click on it it promts the user to enter an email address in the input box. after entering the email, you click OK and at that point, I need for it to check and make sure the email address is found in the global address book in outlook. if it is found the run code to automatically send the Excel spreadsheet to the specified address. Is that possible?
If that isn't possible then next option .....
2. Is there a way to access the current user's global address book in outlook from Excel? For example. When the user clicks btn1 .. the address book is activated and the user can select the email address and then run code to automatically send the Excel spreadsheet to the specified address.
Any help is appreciated.
Thanks