Send email to just one, fixed email address

[Tay]

I apologise in advance if this is a stupid question.

In one db, I have a form where users can choose an email address from a combo, then press a button to send an email to that person. This works perfectly.

In another db, I want to do something similar. The difference here is that the email will only need to be sent to one, fixed email address; users never need to choose it and should just submit this info via a button. Therefore, I figured that I don't need to store this in a table and let users choose it from a combo, I should just be able to hard code it, IYSWIM.

The function I'd hoped to modify is

Call Addto ()

I've no idea how to do this, and my searches for inspiration have proved fruitless. I'm hoping I'm just missing something really basic. Any ideas would be greatly appreciated.

 

[John Big Booty]

You're going to have to show us the code that is in your function Call Addto ()

You could just use the SendObject method.

 

[Tay]

Thanks for replying, and sorry to have wasted your time. Although indirectly, you did help me as your reply prompted me to paste the code... I opened the wrong module and found inspiration there!

I was missing something really basic - I'd not enclosed the required email address in quotes. And I thought I'd tried everything!

 

[John Big Booty]

Inspiration can come from the strangest of places sometimes