Need Experts Help Please 
Author Message
 Need Experts Help Please

I would like to know if this is possible to do in outlook 2000 with
VBA.

I would like my client to be able to go to my website fill out a form
and have an email sent to a specified address that is formatted in a
certain way.  All this is done and works.  The big question is I would
like to have outlook(vba)  process the mail and extract info from the
body ( I got that working also) , I then need to grab one element of
the email and use it as the argument to a command line license
generator.  I woul dthen like to capture the output of that program
and send an email back to the client with his new license information.
I have been able to do the email part also.  The part I can't figure
out is how to run the cmdline(dos) program from VBA and feed it a
argument and capture the output.

If this is possible please supply any help that you can.

Karlo S.  



Sun, 20 Jul 2003 14:16:32 GMT  
 Need Experts Help Please
Use the Shell cmd, not sure if it will pass back arguments

Maarten


Quote:
> I would like to know if this is possible to do in outlook 2000 with
> VBA.

> I would like my client to be able to go to my website fill out a form
> and have an email sent to a specified address that is formatted in a
> certain way.  All this is done and works.  The big question is I would
> like to have outlook(vba)  process the mail and extract info from the
> body ( I got that working also) , I then need to grab one element of
> the email and use it as the argument to a command line license
> generator.  I woul dthen like to capture the output of that program
> and send an email back to the client with his new license information.
> I have been able to do the email part also.  The part I can't figure
> out is how to run the cmdline(dos) program from vba and feed it a
> argument and capture the output.

> If this is possible please supply any help that you can.

> Karlo S.



Sun, 20 Jul 2003 22:31:49 GMT  
 Need Experts Help Please
Look in the Help for the Run command for Windows Scripting. That will
let you run your program with a commandline. The Help file you want is
Wsh.chm but the example for Run is wrong. You don't use the Wscript
before the CreateObject function.

--
Ken Slovak
[MVP - Outlook]
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Co-author of "Programming Microsoft Outlook 2000", Chapters 8-13,
Appendices, Sams


Quote:
> I would like to know if this is possible to do in outlook 2000 with
> VBA.

> I would like my client to be able to go to my website fill out a
form
> and have an email sent to a specified address that is formatted in a
> certain way.  All this is done and works.  The big question is I
would
> like to have outlook(vba)  process the mail and extract info from
the
> body ( I got that working also) , I then need to grab one element of
> the email and use it as the argument to a command line license
> generator.  I woul dthen like to capture the output of that program
> and send an email back to the client with his new license
information.
> I have been able to do the email part also.  The part I can't figure
> out is how to run the cmdline(dos) program from vba and feed it a
> argument and capture the output.

> If this is possible please supply any help that you can.

> Karlo S.



Sun, 20 Jul 2003 22:36:15 GMT  
 Need Experts Help Please
That leave the cmd(dos) window open how can this be closed? I don't
see that option in the intWindowStyle .  I notice in the help that I
don't have access to the spawned process I/O stream, isn't that what I
want?

Karlo S.

On Wed, 31 Jan 2001 09:36:15 -0500, "Ken Slovak - [MVP - Outlook]"

Quote:

>Look in the Help for the Run command for Windows Scripting. That will
>let you run your program with a commandline. The Help file you want is
>Wsh.chm but the example for Run is wrong. You don't use the Wscript
>before the CreateObject function.



Sun, 20 Jul 2003 23:05:31 GMT  
 Need Experts Help Please
You would have to have your DOS program write the return data to a
file or to environment variables. Does your program have a way to exit
and close the command window? I'm not sure about any other way of
closing it.

--
Ken Slovak
[MVP - Outlook]
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Co-author of "Programming Microsoft Outlook 2000", Chapters 8-13,
Appendices, Sams


Quote:
> That leave the cmd(dos) window open how can this be closed? I don't
> see that option in the intWindowStyle .  I notice in the help that I
> don't have access to the spawned process I/O stream, isn't that what
I
> want?

> Karlo S.



Sun, 20 Jul 2003 23:16:28 GMT  
 Need Experts Help Please
No it cannot close the window itself.  The whole idea was to basicaly
do this: licensegen code
where licensegen is a dos program
code is the argument ie "12345678"

the output from the dos program is a printf to STDOUT

I just needed to grab that STDOUT line and send it via email back to
my customer.

Th edos program was written in C++ (I did not write it) if there is a
instruction that I can insert into the C++ code that will destroy the
window it's operating in  I might be able to add that into the program
and recompile.

Thanks

Karlo S.

On Wed, 31 Jan 2001 10:16:28 -0500, "Ken Slovak - [MVP - Outlook]"

Quote:

>You would have to have your DOS program write the return data to a
>file or to environment variables. Does your program have a way to exit
>and close the command window? I'm not sure about any other way of
>closing it.



Sun, 20 Jul 2003 23:32:28 GMT  
 Need Experts Help Please
Karlo,

try to launch BAT file like this:

licensegen.exe %1 > resuls.txt
EXIT

Regards,
Victor



Quote:
> No it cannot close the window itself.  The whole idea was to basicaly
> do this: licensegen code
> where licensegen is a dos program
> code is the argument ie "12345678"

> the output from the dos program is a printf to STDOUT

> I just needed to grab that STDOUT line and send it via email back to
> my customer.

> Th edos program was written in C++ (I did not write it) if there is a
> instruction that I can insert into the C++ code that will destroy the
> window it's operating in  I might be able to add that into the program
> and recompile.

> Thanks

> Karlo S.

> On Wed, 31 Jan 2001 10:16:28 -0500, "Ken Slovak - [MVP - Outlook]"

> >You would have to have your DOS program write the return data to a
> >file or to environment variables. Does your program have a way to
exit
> >and close the command window? I'm not sure about any other way of
> >closing it.

Sent via Deja.com
http://www.deja.com/


Mon, 21 Jul 2003 14:43:40 GMT  
 
 [ 7 post ] 

 Relevant Pages 

1. Please, need help with EXPERT SYSTEM

2. Please, need help with EXPERT SYSTEM

3. ImgEdit.ocx (Expert Help Needed) Please!!!

4. ImgEdit.ocx (Expert Help Needed) Please!!!

5. PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP,

6. Need finding VB / Access / C++ Expert - PLEASE!

7. IE5 - vbscript expert needed please

8. Please, Please, Please I need help working with dates

9. Please, Please, Please I need your help with Winsock

10. HELP NEEDED PLEASE PLEASE PLEASE!!!!

11. EnumEnhMetaFile Help Needed! (Please Please Please)

12. Please Please help !!! Crystal Report Help Needed

 

 
Powered by phpBB® Forum Software