Send Objects

[Nicole]

Is there a way use an expression in the sendobject
function that will select the recipient of the email from
a list of emails given certain criteria?
Thanks
Nicole

 

[Steve Schapel]

Nicole,

Can you give some more information about this? Maybe an example?

- Steve Schapel, Microsoft Access MVP

 

[Guest]

Steve
For example right now when I am using the sendobject
function in my macro the To line will only accept an email
address I type in eg nicole @yahoo.com I would like
however to be able to us the text from [forms]![formname]!
[email address],where[email address] is a string of text
which has (e-mail address removed) in it, to specify the recepient
of the email. I do not think this can be done directly
but was hoping that some other functions or VB would be
able to help me to this
Thanks
Nicole

 

[Steve Schapel]

Nicole,

Yes, it can be done directly. Of course, the form has to be open at
the time. Put a = in front of the expression, i.e.
=[forms]![formname]![email address]

- Steve Schapel, Microsoft Access MVP

 

[Guest]

Steve,
Thanks I forgot about putting an equal sign
Nicole

-----Original Message-----
Nicole,

Yes, it can be done directly. Of course, the form has to be open at
the time. Put a = in front of the expression, i.e.
=[forms]![formname]![email address]

- Steve Schapel, Microsoft Access MVP

Steve
For example right now when I am using the sendobject
function in my macro the To line will only accept an email
address I type in eg nicole @yahoo.com I would like
however to be able to us the text from [forms]! [formname]!
[email address],where[email address] is a string of text
which has (e-mail address removed) in it, to specify the recepient
of the email. I do not think this can be done directly
but was hoping that some other functions or VB would be
able to help me to this
Thanks
Nicole

.