ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting a default profile when invoking Outlook in a Procedure (https://www.excelbanter.com/excel-programming/302325-setting-default-profile-when-invoking-outlook-procedure.html)

DoctorV

Setting a default profile when invoking Outlook in a Procedure
 
I have a line of code in an Excel Workbook that invokes the Outlook sen
dialog box and loads the "To" address, but every time it comes up wit
a dialog box with Choose Profile and Profile names listed in
dropdown

How can I specify the default Profile when I invoke Outlook?

Here is my line of code to invoke Outlook. Thanks

Application.Dialogs(xlDialogSendMail).Sho
.ActiveSheet.Range("b4").Valu

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com