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]

Read above, I had edited the code for you If your code is macro enabled then change the extensions to the macro enabled extension of the file if you know what i mean

EX. blah.xlsx, xlsx is an extension :P

 

[CBurgess]

Maybe this is me being dumb, but if I send my workbook to someone who can't gain access to that location they wont be able to attatch it surely?

I want everyone who uses the workbook regarding of their access to be able to send the PDF along with their emails, without sending them the PDF to save locally themselves.

 

[EPURON]

They will have access as long as the server they save it to gives them permission to access it

And yes they can send the pdf to others if you don't password protect the file or anything

NOTE: They don't need the code to attach files onto outlook

 

[CBurgess]

Which is the problem haha! Sometimes they won't even have access to the server (Outside Sales guys etc) which is why i was focussing on using the already embedded file :D haha Maybe i should of been clearer! Attatching from a fixed location on the server is fine for me, but I won't be the one using the workbook.

To give a breif overview of what we're doing, it's a magical visual contraption that the outside sales guys will use to show customers, that gives then them an option to email everything back to the office to the Internal Sales guys to process it.

Not everyone will have access to the server, but they will have access to the workbook.

 

[CBurgess]

But if you click the email button it'll pull it from the location/server that I have access to. They won't have that access and I'm not giving them a local file. It's got to be the embedded version, maybe it can't be done but we want everything to run through this one system.

 

[EPURON]

I'm sure it will be fine. I've downloaded many excel files and i've never got a location error but when i'm getting excel files from a server then it gives me a location error because that server is going into many other computers. I'd suggest sending it to each person that will be getting the file.

 

[EPURON]

Also you can copy and paste the file on the server onto the desktop of the persons computer and run it off of the computer instead of the server.

 

[CBurgess]

"You want to share a excel file to a company and the pdf file is already saved into a excel file?"

Just seen this, sort of yeah. Excel file gets shared, within Excel file is a PDF. also within Excel file an button to email the Sales office, I want the already embedded PDF to accompany the email.



I think maybe I'm just confusing myself, sending the PDF with the Excel file is the easy option! ahha. Sadly it's not my call! Cheers though.

 

[EPURON]

Solved?

I just wanted to know if the code worked out for you :D

 

[CBurgess]

Yeah I know how to link the file directly from a fixed location. It's just pulling it from an embedded sheet that I'm confused about!