Sign in to follow this  
Followers 0
Max in montreal

simple email question

2 posts in this topic

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



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  
Followers 0