e.mail . from field " assigned to " (1 Viewer)

rainbows · Mar 14, 2019

hi

I have a form called input table of which there is a field called " assigned to"

I have a button on the top of my form called " e.mail

the idea is when I want to send a e mail it looks at the assigned to and sends the details to him .

at this time it keeps giving me an error and I Dont know why
could you please look at my database as help me

please select " edit deviation report " and type in 5 or 6 to get to a completed form

thank you
steve

essaytee · Mar 14, 2019

What is the error reported by Access?

June7 · Mar 14, 2019

Remove space that is in FROM address mike. Hawkins

You are using ID to search for email but the combobox does not include ID in RowSource. You are saving Employee names not IDs into input.

=DLookUp("[E-mail Address]","Employees","[Employee]='" & Nz([To],"") & "'")

The Replace() is not finding Title field.

I recommend using VBA instead of macro - I never use macros. You already have some VBA, why not continue with VBA?

rainbows · Mar 14, 2019

Hi

space removed
this is the error

Code:

 costs1, Excel97-Excel2003Workbook(*.xls), =DLookUp("[E-mail Address]","employees","[ID]=" & Nz([Assigned To],0))

error number 2950

thanks
steve

June7 · Mar 14, 2019

You read my previous post before I finished editing. Might review again.

rainbows · Mar 14, 2019

thank you
all working great

steve

e.mail . from field " assigned to " (1 Viewer)

rainbows

Registered User.

Attachments

essaytee

Need a good one-liner.

June7

AWF VIP

rainbows

Registered User.

June7

AWF VIP

rainbows

Registered User.

Similar threads

Users who are viewing this thread