Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin

You should only get one e-mail, not two. BCC just means other people on the
distruibution list won't see your name on the distriobution. It doesn't
change the number of copies of the e-mail that is sent.

"alvin Kuiper" wrote:

Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin

Ok
But what i want is to send the mail to someone
and send the same mail to another using Bcc
To test it i just use my mail acount
And i have try this

addee = "
With objMail
.To = addee
.BCC = "
.Subject = "Booking"
.HTMLBody = msg
'On Error GoTo cancelvalgt
.Send
End With

So how can i send the same mail using Bcc
To another person.

Alvin

"Joel" skrev:

You should only get one e-mail, not two. BCC just means other people on the
distruibution list won't see your name on the distriobution. It doesn't
change the number of copies of the e-mail that is sent.

"alvin Kuiper" wrote:

Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin

Ok
But what i want is to send the mail to someone
and send the same mail to another using Bcc
To test it i just use my mail acount
And i have try this

addee = "
With objMail
.To = addee
.BCC = "
.Subject = "Booking"
.HTMLBody = msg
'On Error GoTo cancelvalgt
.Send
End With

So how can i send the same mail using Bcc
To another person.

Alvin
"Joel" skrev:

You should only get one e-mail, not two. BCC just means other people on the
distruibution list won't see your name on the distriobution. It doesn't
change the number of copies of the e-mail that is sent.

"alvin Kuiper" wrote:

Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin

outlook is smart (no, honest it is!)
it will "recognise" duplicate mail addresses and not sent the addressee more
than one mail. If you put your own address in the TO and the BCC
you'll get the one copy
you don't need to have anything in the TO field. just use the BCC field

"alvin Kuiper" wrote in message
...
Ok
But what i want is to send the mail to someone
and send the same mail to another using Bcc
To test it i just use my mail acount
And i have try this

addee = "
With objMail
.To = addee
.BCC = "
.Subject = "Booking"
.HTMLBody = msg
'On Error GoTo cancelvalgt
.Send
End With

So how can i send the same mail using Bcc
To another person.

Alvin
"Joel" skrev:

You should only get one e-mail, not two. BCC just means other people on
the
distruibution list won't see your name on the distriobution. It doesn't
change the number of copies of the e-mail that is sent.

"alvin Kuiper" wrote:

Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin

Ok thanks
is working
Now when i send this message
it is from my mail acaount, can i write another
mail acount, on that way so when someone click
on reply then the maill adress i another adress.
alvin


"Patrick Molloy" skrev:

outlook is smart (no, honest it is!)
it will "recognise" duplicate mail addresses and not sent the addressee more
than one mail. If you put your own address in the TO and the BCC
you'll get the one copy
you don't need to have anything in the TO field. just use the BCC field

"alvin Kuiper" wrote in message
...
Ok
But what i want is to send the mail to someone
and send the same mail to another using Bcc
To test it i just use my mail acount
And i have try this

addee = "
With objMail
.To = addee
.BCC = "
.Subject = "Booking"
.HTMLBody = msg
'On Error GoTo cancelvalgt
.Send
End With

So how can i send the same mail using Bcc
To another person.

Alvin
"Joel" skrev:

You should only get one e-mail, not two. BCC just means other people on
the
distruibution list won't see your name on the distriobution. It doesn't
change the number of copies of the e-mail that is sent.

"alvin Kuiper" wrote:

Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin

For Excel/Outlook 2007 see
http://www.rondebruin.nl/mail/account.htm

For older versions and 2007 you can use

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
.SentOnBehalfOfName = """SenderName"" "





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"alvin Kuiper" wrote in message ...
Ok thanks
is working
Now when i send this message
it is from my mail acaount, can i write another
mail acount, on that way so when someone click
on reply then the maill adress i another adress.
alvin


"Patrick Molloy" skrev:

outlook is smart (no, honest it is!)
it will "recognise" duplicate mail addresses and not sent the addressee more
than one mail. If you put your own address in the TO and the BCC
you'll get the one copy
you don't need to have anything in the TO field. just use the BCC field

"alvin Kuiper" wrote in message
...
Ok
But what i want is to send the mail to someone
and send the same mail to another using Bcc
To test it i just use my mail acount
And i have try this

addee = "
With objMail
.To = addee
.BCC = "
.Subject = "Booking"
.HTMLBody = msg
'On Error GoTo cancelvalgt
.Send
End With

So how can i send the same mail using Bcc
To another person.

Alvin
"Joel" skrev:

You should only get one e-mail, not two. BCC just means other people on
the
distruibution list won't see your name on the distriobution. It doesn't
change the number of copies of the e-mail that is sent.

"alvin Kuiper" wrote:

Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin

Hi
Thanks
I can't get it to use a variabel
Dim saelger As String
Dim saelgermail As String
saelgermail = Range("beregn!$d$30").Value
saelger = """SenderName"" & salgermail & "

..SentOnBehalfOfName = saelger

Alvin
"Ron de Bruin" skrev:

For Excel/Outlook 2007 see
http://www.rondebruin.nl/mail/account.htm

For older versions and 2007 you can use

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
.SentOnBehalfOfName = """SenderName"" "





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"alvin Kuiper" wrote in message ...
Ok thanks
is working
Now when i send this message
it is from my mail acaount, can i write another
mail acount, on that way so when someone click
on reply then the maill adress i another adress.
alvin


"Patrick Molloy" skrev:

outlook is smart (no, honest it is!)
it will "recognise" duplicate mail addresses and not sent the addressee more
than one mail. If you put your own address in the TO and the BCC
you'll get the one copy
you don't need to have anything in the TO field. just use the BCC field

"alvin Kuiper" wrote in message
...
Ok
But what i want is to send the mail to someone
and send the same mail to another using Bcc
To test it i just use my mail acount
And i have try this

addee = "
With objMail
.To = addee
.BCC = "
.Subject = "Booking"
.HTMLBody = msg
'On Error GoTo cancelvalgt
.Send
End With

So how can i send the same mail using Bcc
To another person.

Alvin
"Joel" skrev:

You should only get one e-mail, not two. BCC just means other people on
the
distruibution list won't see your name on the distriobution. It doesn't
change the number of copies of the e-mail that is sent.

"alvin Kuiper" wrote:

Hi!
I have try this
After my mail setup last line:
msg = msg & "</table"
then i try this
Set objRecip = objMail.Recipients.Add("Mymail")
objRecip.Resolve
If objRecip.Resolved Then
objRecip.Type = olBCC ' 3
End If
addee = "Mymail"
With objMail
.To = addee
.Subject = "Booking"
.HTMLBody = msg
On Error GoTo cancelvalgt
.Send
End With

I get my mail, with addee
But not the Bcc mail
What is wrong here?

Alvin