Email Through Outlook

[ProfessorIII]

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 -

[Oleg]

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"

[Oleg]

There is "Send email" action to send a message. Combine this action with database loop for automated delivery of messages.