I want to create a macro so that access will open up outlook and put the email address in of the person whose record is on the screen-is there an easy way to do this? Thanks in anticipation
Yes you can do this using the Microsoft Outlook Object library and create an instance of outlook. Do you know much VBA? I have seen examples of how to use this library posted here do a search for some code but basically you with the Outlook instance(object) you can create a new email with the subject and body you want and sent it (or save it as a draft) to whomever you wish.
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.