I have a simple button which creates a Memo document within a database and then mails it. For some reason the From is always the Server Administrator id with a Sent By below this. How can I ensure that the email is sent from the id actually creating it? Here is how the document is created ’ very simple.
Set uidocNew = wks.ComposeDocument( “”, “”, “Memo” )
Call uidocNew.FieldSetText("SendTo",docCurrent.Requester(0))
Call uidocNew.FieldSetText("EnterSendTo",docCurrent.Requester(0))
Call uidocNew.FieldSetText("Subject","Demand Tool Reference ID : " & docCurrent.Subject(0))
Call uidocNew.GotoField( "Subject" )