Jump to content
Sign in to follow this  
Max in montreal

simple email question

Recommended Posts

Max in montreal

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.ca

st123emp@email.ca

st123bos@email.ca

every 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 number

cuts cust name from a window from another window

cuts po number from that same window

creates an email using outlook with:

to :st123mgr@email.ca; st123emp@email.ca; st123bos@email.ca

Subject: the cut PO number

Body:

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!

Share this post


Link to post
Share on other sites
water

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.