I would like to get Outlook to do the following.
1. Check incoming emails for sender's name, subject and attachement.
2. Save the attachement locally.
3. Run a MS Excel VBA macro that processes the saved file.
4. Sends the processed file back to the sender.
Is the possible with Outlook?
Would...
I have 2 ideas
1 Add the foolowing before Set dbs = CurrentDb
Dim dbs as Database
Dim rst as Recordset
2 Put the strSQL into a Query and save it and change
Set rst = dbs.OpenRecordset("QueryName")
Also check References.
Might help
Does anyone have a 2002 VBA procedure to recursively fill a TreeView. I've found a 97 version on MS Knowledge base No. 167309, but I can't get it to work in 2002.
Any help would be greatfully recieved.
Could anyone show / explain how I can read the Caption text of the Field properties of a table in VBA, preferably using a recordset.
Any help would be greatfully received.
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.