Object variable error when adding receipts to MS Outlook

[Pi*]

Hi,

Could you please assist me in correcting a Run time error 91 "Object variable or With block variable not set" error I get when I run the below macro. The macro works except that it does not insert the "To" and "Cc receipts in Outlook when I run it. I am currently using MS Outlook 2013 and I have valid e-mail addresses in the cell references B and C.

The below id the portion of macro it highlights when it errors out;

Please Login or Register  to view this content.

The below is the macro I am running;

Please Login or Register  to view this content.

As always I appreciate the assistance.

Pi

[6StringJazzer]

wscontrol is never set. Therefore it is NULL at the time your statement is executed.

[Pi*]

I appreciate it 6StringJazzer. Would you be able to tell me where in the vba I will have to Set it so it works.

I appreciate your time.

Pi

[6StringJazzer]

There is not enough information for me to know how you are intending to use it. It can be set anywhere before it is used

Please Login or Register  to view this content.

but I don't know what you want to set it to.

[Pi*]

I have the send "To" recipients of the e-mail in cell B74 and the "CC" recipients of the e-mail in cell C74 both on the Control tab. What I want the macro to do is as part of creating a pdf and attaching to the e-mail I also want it to paste the To and CC recipients in cells B74 and C74 on the Control tab into the "sent to" and "cc" of MS Outlook and send. If that is possible.

I appreciate your time and helping e with this.

Pi

[6StringJazzer]

You need to change your declaration for wscontrol to

Please Login or Register  to view this content.

Then add this line near the top of your code:

Please Login or Register  to view this content.

[Pi*]

Thank you 6StringJazzer. It works perfect now.

Most appreciated.

Pi*