Access 2010 - Using Macros to send an email from access to outlook

[PrettyMess]

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:

setlocalvar name varBodyTitle
expression = concat('HTML Style goes in here wont display right',[MobileNumber],"Update to Mobex",'<\h2><br>')

setlocalvar name varBodyMain
expression = concat("Look at asap",'<br>',"The following mobex has changed from",[OldValue],"to",[NewValue],'<br>')

setlocalvar name varBodyEnd
concat('<br><br><i>',"this message is sent from an unmonitored email address",'</i>')

sendemail

To ="email address"
cc
bcc
subject ="New Update"
Body =concat([varBodyTitle],[varBodyMain],[varBodyEnd])

Thanks
Paula

 

[alansidman]

Here is an older video that may help you to get what you need. Note that this video is for AC2003, but you should be able to adapt to your needs.

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2