Trying to pass variables from our ERP software.
these are the values:
ORDER_ID = "TEST"
CONTACT_EMAIL = "BBunny@testthis.com; EFudd@testthis.com"
DATABASE = "TESTDB"
This is the code I am trying:
dim shell
set shell = createobject("WSCRIPT.SHELL")
shell.Run """\\CT01\Root\Visual\Scripts\VMPURENT_Email_800.vbs"" """ & "" & """ " & ORDER_ID & " " & CONTACT_EMAIL & " " & DATABASE & " " & USER & " " & fname & " " & "0",,false
Select all Open in new window
\\CT01\Root\Visual\Scripts
\VMPURENT_
Email_800.
vbs
Dim args
Dim Shell
set args = Wscript.Arguments
if args.count = 0 then wscript.quit
MSGBOX "0 Position: " & args(0) & " 1 ID: " & args(1) & " 2 Email: " & args(2) & " 3 Database: " & args(3) & " 4 User: " & args(4) & " 5 first name: " & args(5) & " 6 downs: " & args(6)
Select all Open in new window
agrs(1) contains TEST
agrs(2) contains BBunny@testthis.com
args(3) contains EFudd@testthis.com
args(4) contains TESTDB
args(2) should contain BBunny@testthis.com; EFudd@testthis.com
args(3) should contain TESTDB
what do I need to do to pass a variable that contains a semicolon to another vbs program using shell
will try.