email to

[0 Agios]

whats the equivalent link for BCC, CC and subject, using the following code.

ActiveWorkbook.FollowHyperlink Address:="mailto:chuck@advfireonline.com; & ', NewWindow:=True"

thanks.

 

[Ruddles]

Check this: http://lmgtfy.com/?q=mailto:+cc+bcc

 

[0 Agios]

Check this: http://lmgtfy.com/?q=mailto:+cc+bcc

This did not help is for HTML, any other ideas ?

 

[Ruddles]

Strange... it worked for me. Did you try it?

 

[Ruddles]

ActiveWorkbook.FollowHyperlink Address:="[EMAIL="fred@fred.com;bill@bill.com?cc=test@test.com&bcc=me@me.com&subject=Test"]mailto:fred@fred.com;bill@bill.com?cc=test@test.com&bcc=me@me.com&subject=Test[/EMAIL] message&body=Hello!%0a%0aThis is an email! & ', NewWindow:=True"

 

[0 Agios]

ActiveWorkbook.FollowHyperlink Address:="[EMAIL="fred@fred.com;bill@bill.com?cc=test@test.com&bcc=me@me.com&subject=Test"]mailto:fred@fred.com;bill@bill.com?cc=test@test.com&bcc=me@me.com&subject=Test[/EMAIL] message&body=Hello!%0a%0aThis is an email! & ', NewWindow:=True"

This works thanks.

 

[0 Agios]

ActiveWorkbook.FollowHyperlink Address:="[EMAIL="fred@fred.com;bill@bill.com?cc=test@test.com&bcc=me@me.com&subject=Test"]mailto:fred@fred.com;bill@bill.com?cc=test@test.com&bcc=me@me.com&subject=Test[/EMAIL] message&body=Hello!%0a%0aThis is an email! & ', NewWindow:=True"

If I want to change
subject= to a range in the active page? is that possible?
My range is ("D6")
Thanks.

 

[Ruddles]

If I want to change subject= to a range in the active page? is that possible?
My range is ("D6")

ActiveWorkbook.FollowHyperlink Address:="mailto:fred@fred.com;bill@bill.com?cc=test@test.com&bcc=me@me.com&subject=" & Range("D6") & "&body=Hello!%0a%0aThis is an email! & ', NewWindow:=True"

 

[Ruddles]

This works thanks.

See - you should have believed me the first time!

 

[0 Agios]

See, you should have believed me the first time!

I shoud have .... but I got confused with all the HTML, thanks for the responce

can you help with this ?
If I want to change
subject= to a range in the active page? is that possible?
My range is ("D6")
Thanks.