Email Macro

[Lvalencia]

I created an email macro in tables, basically the macro is to send an email out when a new record is created in a table. However when I test I do not receive an email. Question - does the database have to be web based or on a share point site to work? Will it not work from my PC.
This database eventually will be uploaded to a share point site so it can be used be multiple sites. But I want to make sure that it works as planned prior to upload.
I am not a programmer so writing code would be out of my league.
But the macro is simple: after update
when count number is >1 send email to .....
I appreciate any help, shaking the rust off using access!!

 

[RogerCooper]

You may want to try a different approach. Many things can go wrong when you try to things after update. You may be better off sending the e-mails separately as part of regular day end Macro or something similar.

 

[CJ_London]

I am not a programmer so writing code would be out of my league.

time to learn then

But the macro is simple

except it doesn't work

As roger says, after update, the record is saved and the pointer moved on to a new record. try using the before update event.

You say you do not receive an email - are you sure one has been sent?

does the database have to be web based or on a share point site to work?

with regards sending emails, no. If you are using outlook or other pc/server based email product it is pretty straightforward, if using something like gmail then potentially a lot more work.

 

[Lvalencia]

First off thanks for the responses, I did get my email to work had to send email object. Second question: Can I include information from one of my fields in the email?
Maybe it would be
after update
when count number is >1 send email, include field 1 text description????

Copy and past would work, but my full intent is to include the form view so engineer would see all associated data.

 

[RogerCooper]

Yes. You can use the dlookup function to pull data from a table or recordset.

 

[Lvalencia]

where do you use dlookup at? Currently I am emailing a data base object which sends the entire data base. Do not see dlookup as one of the options in selecting an action.
Thanks for the help

 

[RogerCooper]

where do you use dlookup at? Currently I am emailing a data base object which sends the entire data base. Do not see dlookup as one of the options in selecting an action.
Thanks for the help

If you need to send the entire database, you would probably be better off working outside of Access. To send a table, you can use "EMailDatabaseObject".