Object variable or With block .... sending e-mail CDO

**wrybel** · 06-30-2015, 08:30 AM

Hi,

on one forum I found a maco to send e-mail but it doesn't work. I get an error "Run-time 91 Object variable or With block variable not set"
How can I fix it ?

Thanks for any help !

Please Login or Register  to view this content.

**Norie** · 06-30-2015, 08:32 AM

MI should be declared as String, not Object.

**wrybel** · 06-30-2015, 08:59 AM

Thank's works perfect !

Can I ask one more question is it possible to send and attach the same file with this macro inside ?

Object variable or With block .... sending e-mail CDO

LinkBack

Thread Tools

Rate This Thread

Display

Object variable or With block .... sending e-mail CDO

Re: Object variable or With block .... sending e-mail CDO

Re: Object variable or With block .... sending e-mail CDO

Thread Information

Users Browsing this Thread

Similar Threads

“Object variable or With block variable not set” error while adding data into ArrayList

Macro issue: Object variable or with block variable not set error

VBA Loop, Find & Copy run-time error '91': Object variable or With block variable not set

Object variable or With block variable not set Error during sorting program

Object Variable or With Block Variable Not Set- Error on Another User Machine

Bookmarks

Bookmarks

Posting Permissions