-
Need help or advice on creating an Excel macro to open an Outlook email.
I have never created macros in excel before. I have some experience with creating macros and templates in Word but don't even know where or how to start in Excel. I have created a department-shared Excel spreadsheet to track equipment. The last cell of each row has a check box for reordering equipment. What I want to have happen in that last cell is that if the user selects it, it will open a stored Outlook message to send to our procurement department. Is this possible and if so, how do I do it. All help or suggestions for an easier way are appreciated. i am using Office 2010 but can also use 2016.
-
.
Ron de Bruin is the expert on VBA email. Here is his website on emails : https://www.rondebruin.nl/win/s1/outlook/mail.htm
It sounds like you are wanting to email a range from the active sheet. So ... start with that selection from the page presented on his website.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules