Variable for email address sender
 

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.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.BCC= email address sender
Item.Send
End Sub

Thanks in advance,

Jan Kuijt

Variable for email address sender
 

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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Jan Kuijt" wrote in message ...
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.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.BCC= email address sender
Item.Send
End Sub

Thanks in advance,

Jan Kuijt