Sending Email

[Rob.Mills]

I have a continuous form that has several columns one of them being an email address. I've setup a procedure for On Dbl Click that opens an email addressed to the person in that record with a message. Everything works fine.

But... there's always a but... it won't let me run the procedure again. If I want to email from another record I have to close the database and reopen it each time.

 

[Fornatian]

are you using this code?

Application.FollowHyperlink "mailto:"& Me.FieldWithEmail

 

[Rob.Mills]

No, this is my code:

DoCmd.SendObject acSendNoObject, , , strTo, , , strSubject, strMsg

 

[Fornatian]

You need Tal/BuxHix our resident SendObject expert.

 

[Rob.Mills]

I tried looking that user up and can't find them. Suggestions?

 

[pbuethe]

The correct spelling is BukHix.

 

[Fornatian]

Oh, no what have I done, I will never be forgiven - it was a typo - honest