Okay, my problem is as follows: My "Drawing" is embedded on Sheet1, later on in Sheet12 I click a button that'll send an automatic email to a user. I want to attatch the embedded PDF onto this email if it is at all possible??
After I've declared my variables I've tried setting the variable "Drawing" to the object, this is where I'm encountering my errors mainly "Type Mismatch" or Object Variable not set...
Dim Drawing As Object
At the bottom of the code, this is where i pull in the object
Sheets("Menu").Visible = True Drawing = Sheet1.Shapes.range(Array("Drawing")) Selection.Verb Verb:=xlPrimary Sheets("Menu").Visible = False
Cheers guys, you're help is appreciated.
.To = Sheet12.range("L8") .CC = "" .BCC = "" .Subject = "Arrange P&D Request" .htmlbody = strbody & vbNewLine & Signature .Attachments.Add ("Drawing")
This question generated 55 answers. To proceed to the answers, click here.
This thread is current as of January 14, 2014.