I need to code an Excel macro than will automatically send and email to someone within our company. How do I populate the To: field using Microsoft Outlook?
I have the same situation. I created and Excel workbook that virtually populates all the info on its own. I've created a macro that will put the book into Outlook 2000 but I still have to manually populate who it goes to.
Is it possible to create the macro and have it, upon execution, email the workbook to single person or to a group of persons wothout having to manually enter in who it goes to in the "To" field?
If anyone can help it would be greatly appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.