Imtryin
12-08-2010, 03:16 AM
Hi all
I have a project where it requires email notification automation. I will recieve and email that will always have the same subject line and will contain in the email a file name. The file name is always on the same line.
What i want a script to be able to do is read the email and take out the file name and create a text file then dump just the file name into the text file.
So in a nutshell in really simple terms.
1. i create a rule in outlook which says anything with the subject header 'file ready for download' start VBA script.
2. Vba script to read email and take out file name.
3.Create a text file in C:\curl\TMPfilename.txt
4.put file name in above text file.
5.start batch file C:\curl\getfile.bat
END
Is this possible? or is this asking to much from a VBA script?
Just a word of warning! I have no idea about VBA, i wouldnt know where to start, i can attach a template of the email i will recieve if you need it.
Many Thanks
I have a project where it requires email notification automation. I will recieve and email that will always have the same subject line and will contain in the email a file name. The file name is always on the same line.
What i want a script to be able to do is read the email and take out the file name and create a text file then dump just the file name into the text file.
So in a nutshell in really simple terms.
1. i create a rule in outlook which says anything with the subject header 'file ready for download' start VBA script.
2. Vba script to read email and take out file name.
3.Create a text file in C:\curl\TMPfilename.txt
4.put file name in above text file.
5.start batch file C:\curl\getfile.bat
END
Is this possible? or is this asking to much from a VBA script?
Just a word of warning! I have no idea about VBA, i wouldnt know where to start, i can attach a template of the email i will recieve if you need it.
Many Thanks