Most valuable professional
  • Hot Topics

Excel Attatching an already embedded PDF to an Email.

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?? Code: Dim 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... Code: Sheets("Menu").Visible = True Drawing = Sheet1.Shapes.range(Array("Drawing")) Selection.Verb Verb:=xlPrimary Sheets("Menu").Visible = False At the bottom of the code, this is where i pull in the object Code: .To = Sheet12.range("L8") .CC = "" .BCC = "" .Subject = "Arrange P&D Request" .htmlbody = strbody & vbNewLine & Signature .Attachments.Add ("Drawing") Cheers guys, you're help is appreciated.

This question generated 55 answers. To proceed to the answers, click here.

This thread is current as of January 14, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel