Hi All,
I have been asked to make my database send emails when a new record is added or a change is made to the 'mobex' I have managed to get it to record the information in another table but I cant get the email to send
I also don't want it to alert the member of staff that an email is being sent
I need to set this up in a macro to make management of this easier as I will not be maintaing this going forward
If anyone could help it would be greatly appreciated
I have input this data into the after insert command on my table:
Code:
setlocalvar name varBodyTitle
expression = concat('HTML Style goes in here wont display right',[MobileNumber],"Update to Mobex",'<\h2>')
setlocalvar name varBodyMain
expression = concat("Look at asap",'',"The following mobex has changed from",[OldValue],"to",[NewValue],'')
setlocalvar name varBodyEnd
expression = concat('',"this message is sent from an unmonitored email address",'')
sendemail
To ="email address"
cc
bcc
subject ="New Update"
Body =concat([varBodyTitle],[varBodyMain],[varBodyEnd])
Many Thanks in advance
Paula