blat command line does not work in Shell method

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jay

    #1

    blat command line does not work in Shell method

    Not sure who is familiar with the blat program, but I would like to
    send an email using blat by executing a commmand line using the Shell
    method.
    here's my code:
    /=============== =
    Dim RetVal
    strCommand = "C:\Blat240\ful l\blat.exe test.txt -to me@myemail.com"
    RetVal = Shell (strCommand ,vbHide)
    /=============== =
    If I run the string that I assign to strCommand in my "Run" box, it
    works. What am I missing? Thank you for your insight in advance.
    J

    Note: This blat command sends the contents of the "test.txt" file to
    the specified email address in the command.

Working...