Specifying the from field of an e-mail

[scottian]

Im creating a form in a database that will handle new issues. the user will check the issues and either accept or reject. Is it possible to specify the from field of the e-mail to the team name rather than actual e-mail of the user rejecting the record?

"My God! It's full of stars...

 

[AlexCuse]

Are you using CDO to send the email? If so, you can do this using SMTP to send.

If you absolutely need to use outlook I'm not sure if this is possible though.

A wise man once said
"The only thing normal about database guys is their tables".

 

[mp9]

If your email software is Outlook, you will find a solution to specifying the "From" address (and a whole lot of otehr parameters too) at

http://www22.brinkster.com/accessory/modules/005.shtml

-it's the "sender" param in this example that you'll be interested in.

 

[scottian]

MP9

Thank you, ive found 'SenderName, SenderEmailAddress, SenderEmailType' but i cant seem to use them. When i try i get an error along the lines of "cannot assign to read only"
when i try to use .Sender = "Best Team" i get
runtime error "438" object or method not supported

anyone have any ideas..

access97 by the way

"My God! It's full of stars...

 

[mp9]

The code example I referenced uses...

 .SentOnBehalfOfName =