Code for Creating outlook mail then pasting to BCC field?

[methodman]

Hi there,
I'm hoping someone can help me please. I've been trying to make some code or find some code for pasting into the BCC field - but it seems like it hasn't been done.

Basically I have a range of cells (only visible ones) in Excel which I need to paste into the BCC field - but I don't think it possible to do this.

Can someone please help me out with this; and either confirm it or inform me of the code used to do this.

So:

1) Copy range cells
2) Create new mail
3) Paste cells to BCC

[royUK]

You will find what you need here

[methodman]

I've looked on that page - as there where google links mostly pointed to; but correct me if I'm wrong but that only show how to paste in to the body of the email not BCC fields and the coding cannot be changed to do that due to the nature of the "".

[snb]

you don't need tot copy to put cellvalues in a BCC-field
If you want the email adress in cell C1 to C3 in the BCC-field

Please Login or Register  to view this content.

[methodman]

Hi there, That code doesn't work - it doesnt seem to open MS outlook 2003 - any idea why this is?
It works when I use:
Link = "mailto:" - but I don't know how to paste using that command.

[methodman]

Ok this code work - but it attachs the whole sheet to the email and sends it without me clicking send.

All I need to do is simple copy all the range into the BCC field and leave it open.

Please Login or Register  to view this content.

[methodman]

Is there anyone that knows how to do this?