Email

[AJ1971]

Hi,
​

I hope someone can help, I want to be able to send an email on completing a form using a field within the form if possible, here is what I have...

Tickets - Datasheet
New Ticket - Form

• AssignedtobyUserID
  • Row Source - (Users table) ID, Email and Full name

I have 2 command buttons - 'Save & New' and 'Save and Close', I would like to be able to send an email to the 'Assigned to' person telling them they have been assigned a new ticket.

I am really struggling with whether this is directly from the form or when the Tickets datasheet is updated.

Can anyone help?

Many thanks in advance.

 

[Minty]

You shouldn't ever let your users get directly to a table, so - the code only needs to go in the forms events.