Max in montreal Posted January 26, 2012 Share Posted January 26, 2012 I work for a big box store and as part of my job I have to send out email to specific stores.email addresses look something like this:st123mgr@email.cast123emp@email.cast123bos@email.caevery store has the same email address, its just the store number that changes.the above example is for store 123.my emails require me to send info to 3 people in the store, so i would like to create a script that...asks me for the store numbercuts cust name from a window from another windowcuts po number from that same windowcreates an email using outlook with:to :st123mgr@email.ca; st123emp@email.ca; st123bos@email.caSubject: the cut PO numberBody:please be advised that we have sent part for CUST NAME under case PO number.only things that change are store number, cust name and po number..I have seen the inetmail function, but it will not work for me. I mean it works but I am hoping there is a better way.any help appreciated in advance! Link to comment Share on other sites More sharing options...
water Posted January 27, 2012 Share Posted January 27, 2012 For Outlook 2007 and later you could use my OutlookEX UDF. Search for function _OL_Wrapper_SendMail to easily send an email. For download please check my signature. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now