Variable for email address sender

[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

 

[Sue Mosher [MVP-Outlook]]

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.