Attatching an already embedded PDF to an Email.

[CBurgess]

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??

  Dim Drawing As Object

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...

    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

        .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.

 

[EPURON]

Yeah im getting confused too. Never though you can embedded pdf files onto excel hahah :P

 

[CBurgess]

Not really, I appreciate the help but I can't give out the file and give it to people, it's all got to be stored inside this one Excel Database, so if I can't pull an attatchment from an embedded sheet I'll just not include it.

 

[EPURON]

Yeah i understand I wouldn't give out personal information out as well :D

 

[CBurgess]

File > Insert > Object > PDF

Then I hide the object.

So a Datasheet will be hidden, once the relevant information is entered and user clicks the button the correct DataSheet then becomes visible and appears, It's all magic really, but I want to be able to send it with an email as well. All automatically ha

 

[EPURON]

I know this is probably bugging you but i'm somewhat confused. Like automatically you mean like. As soon as that person receives that excel file with the embedded pdf file in it, You want it to open the PDF inside the excel file with the other personal information? :D

Reply asap

 

[CBurgess]

Oh no,

Basically I sent Excel file to the very lucky user,

He goes through it with a customer, choosing what they may or may not want, all the options would be stored and are automatically structured into an email template that is sent once the user clicks Raise P&D.

There is a PDF stored inside the excel sheet that's sort of a "key" that can be accessed by the user, but they wont have a local copy of it. The PDF will then "hopefully" be sent along with the email, to help anyone understand what is requested from them.

 

[EPURON]

There we go. Beautiful explanation!

 

[EPURON]

Okay so im gonna edit the code which will be very easy and ill explain what to do. Give me a good 5 minutes

 

[CBurgess]

Thank you, so my problem is how to attatch an already embedded PDF. If it's even possible.

 

[CBurgess]

Hero