Variable for email address sender

  • Thread starter Thread starter Jan Kuijt
  • Start date Start date
J

Jan Kuijt

Hi,

I have designed a message form in Outlook 2002. I use a clickable 'Submit'
button.

De code is (thanks Sue)

Sub Submit_Click()
Item.To="(e-mail address removed)"
Item.Send
End Sub

Now I want every time a user sends the form he receives a copy to his own
mailbox.
(For other reasons I cannot use the Sent Items for that)

So what has to be the variabele for: email address sender.

Sub Submit_Click()
Item.To="(e-mail address removed)"
Item.BCC= email address sender
Item.Send
End Sub

Thanks in advance,

Jan Kuijt
 
You can try Application.Session.CurrentUser.Address but (a) it will give you a security prompt and (b) it won't necessarily work, depending on the type of mail account in use.
 
Back
Top