Send Objects

N

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
 
S

Steve Schapel

Nicole,

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

- Steve Schapel, Microsoft Access MVP
 
G

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 [email protected] 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
 
S

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
 
G

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 [email protected] 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
Click to expand...

.
Click to expand...
 
Top