Send Objects

  • Thread starter Thread starter Nicole
  • Start date Start date
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
 
Nicole,

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

- 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
 
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,
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
Click to expand...

.
Click to expand...
 
Back
Top