Hi,
I want to send mail with access, but there are a couple of variables (to, cc, bcc, subject, body, att) that have to be typed on the command line. I've searched and searched a correct way to call a function from the command line, but can't seem to succeed.
I have a function (fn_sendmail) that works if i set the variables hardcoded. When opening the DB a macro calls the function.
Macro1 = openprocedure (sorry for the dutch) Functionname: fn_sendmail()
This is the code i put in dos
I've tried to quote the variables, put them between brackets, used semicolon but nothing works!
Can somebody please point me in the right direction?
Tnx in advance
I want to send mail with access, but there are a couple of variables (to, cc, bcc, subject, body, att) that have to be typed on the command line. I've searched and searched a correct way to call a function from the command line, but can't seem to succeed.
I have a function (fn_sendmail) that works if i set the variables hardcoded. When opening the DB a macro calls the function.
Macro1 = openprocedure (sorry for the dutch) Functionname: fn_sendmail()
This is the code i put in dos
Code:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "G:\mail_test.mdb" /x Macro1 /cmd to, cc, bcc, subject, body, attCan somebody please point me in the right direction?
Tnx in advance
