ExcelBanter - control Outlook Address book from Excel VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - control Outlook Address book from Excel VBA (https://www.excelbanter.com/excel-programming/399470-control-outlook-address-book-excel-vba.html)

PhilM[_2_]

control Outlook Address book from Excel VBA

I have a spreadsheet that mails via outlook automatically. At the
moment the user has to type in the email address of the recipient via
an input box. How can I get VBA to open the outlook address book
similar to sending an email via outlook normally?

All times are GMT +1. The time now is 08:15 AM.