This tool lets you reset recent addresses that Outlook has stored, and delete recent addresses all at once, instead of one at a time. The image above shows what happens if an invalid date is selected, conditional formatting hides the day to alert the user that the date is invalid. The named range is dynamic, all drop down lists in each row is connected. Copy cell A1:C1 Paste down as far as needed. Then Outlook opens a new email whenever you click on a mailto: link in an email or website. How to create a list of drop down calendars. All other NFL-related trademarks are trademarks of the National Football League. If youre running Catalina on your Mac and iPadOS 13 on your iPad, click the AirPlay button, and in the drop-down menu youll see a section labeled Connect. This tool lets you choose Outlook for Mac as your default mail application. Re: How to insert a date picker as a drop down menu in Microsoft Excel 2019 for mac Hi Akrust00, Assuming you have access to office add-ins (developer tab, Add-ins) there is an excellent add-in called Calendar by WavePoint Co. NFL and the NFL shield design are registered trademarks of the National Football League.The team names, logos and uniform designs are registered trademarks of the teams indicated.