Hello -
I have an access db that contains Macros to send data on a daily basis. I get as far as opening the email, however, Outlook has some kind of security that it will not "send" automatically. Someone referred me to this functionality. How can I leverage this software with my access db macro's - sending emails autonmatically?
thanks -
Email Through Outlook
-
- Posts: 1
- Joined: Thu Oct 27, 2005 11:49 am
- Location: United States
Email Through Outlook
See example below. You should change connection string and, probably, query text to make this example correct.
In query text you can use user or system variable, like this:
select * from emp where deptno = {DepCode}
DepCode - is a user variable.
Database loop assign array of field names and fied values into user defined variables as comma-seaprated text. You can access to each item by number
{fields(0)} , {fields(1)}, {fields(2)}, {row(0)}, {row(1)}, {row(2)}
;**********************
;* RoboTask Task file *
;* Do not edit! *
;**********************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|986933141
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task320"
Hide=INTEGER|0
ID=INTEGER|853451195
Name=STRING|"Database loop example"
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
[Actions\Action1]
ActionID=STRING|"A_DIALOG_INPUTBOX"
Enabled=INTEGER|-1
Name=STRING|"Input Box"
Params=FOLDER
[Actions\Action1\Params]
prompt=STRING|"Enter DepCode"
variable=STRING|"DEPCODE"
[Actions\Action2]
ActionID=STRING|"A_LOOP_DATASET"
Enabled=INTEGER|-1
Name=STRING|"Dataset Loop"
Params=FOLDER
[Actions\Action2\Params]
commatext=STRING|"0"
connectionstring=STRING|"Provider=MSDASQL.1;Persist Security Info=False;Data Source=DBDemo"
override=STRING|"0"
password=STRING|"2005621129188291960170144"
sql=STRING|"""select * from emp where deptno = {DepCode}"""
var1=STRING|"FIELDS"
var2=STRING|"ROW"
withmemo=STRING|"0"
[Actions\Action3]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""{fields(0)}: {row(0)}"""
Params=FOLDER
[Actions\Action3\Params]
icon=STRING|"1"
msg0=STRING|"{fields(0)}: {row(0)}"
msg1=STRING|"{fields(1)}: {row(1)}"
msg2=STRING|"{fields(2)}: {row(2)}"
msgcount=STRING|"3"
playsound=STRING|"0"
showmessage=STRING|"1"
[Actions\Action4]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
In query text you can use user or system variable, like this:
select * from emp where deptno = {DepCode}
DepCode - is a user variable.
Database loop assign array of field names and fied values into user defined variables as comma-seaprated text. You can access to each item by number
{fields(0)} , {fields(1)}, {fields(2)}, {row(0)}, {row(1)}, {row(2)}
;**********************
;* RoboTask Task file *
;* Do not edit! *
;**********************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|986933141
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task320"
Hide=INTEGER|0
ID=INTEGER|853451195
Name=STRING|"Database loop example"
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
[Actions\Action1]
ActionID=STRING|"A_DIALOG_INPUTBOX"
Enabled=INTEGER|-1
Name=STRING|"Input Box"
Params=FOLDER
[Actions\Action1\Params]
prompt=STRING|"Enter DepCode"
variable=STRING|"DEPCODE"
[Actions\Action2]
ActionID=STRING|"A_LOOP_DATASET"
Enabled=INTEGER|-1
Name=STRING|"Dataset Loop"
Params=FOLDER
[Actions\Action2\Params]
commatext=STRING|"0"
connectionstring=STRING|"Provider=MSDASQL.1;Persist Security Info=False;Data Source=DBDemo"
override=STRING|"0"
password=STRING|"2005621129188291960170144"
sql=STRING|"""select * from emp where deptno = {DepCode}"""
var1=STRING|"FIELDS"
var2=STRING|"ROW"
withmemo=STRING|"0"
[Actions\Action3]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""{fields(0)}: {row(0)}"""
Params=FOLDER
[Actions\Action3\Params]
icon=STRING|"1"
msg0=STRING|"{fields(0)}: {row(0)}"
msg1=STRING|"{fields(1)}: {row(1)}"
msg2=STRING|"{fields(2)}: {row(2)}"
msgcount=STRING|"3"
playsound=STRING|"0"
showmessage=STRING|"1"
[Actions\Action4]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
Email Through Outlook
There is "Send email" action to send a message. Combine this action with database loop for automated delivery of messages.