run-timer error 438 trying to attach file to outlook

Originally Posted by AlphaFrog

Here's a step-by-step guide with code.

Email one sheet as PDF attachment.

Alot of excel specific stuff (xls files) otherwise it was the same except destwb and attachtents.add destwb.fullname did not work in my case will se if I can find the path to my file somehow

Originally Posted by Norie

Try this.

Please Login or Register  to view this content.

Originally Posted by elfor

run-timer error 438 trying to attach file to outlook

Not sure if i'm using file = correct (set file) do not work, or if it's something else.

Please Login or Register  to view this content.

Didn't work strFileName only contains the filename

Originally Posted by AlphaFrog

Your original code does not define a path for the file name. So it saves to the last used windows path which could be anything.

Define the path when you define the file name. Then you know the path. e.g;

Please Login or Register  to view this content.

Lol yes, just figured that out but it still doesn't work :D

Runtime error 438 object doesnt support this property or method, next step might be to check if Excel 2010 (european/swedish) version really supports this but can't see why not. Or if i need to define as type or something somehow im just a vbscript guy vbscript doesn't need stuff defined

Yes and that doesn't work

Please Login or Register  to view this content.

[QUOTE=AlphaFrog;4667240]

Originally Posted by elfor

Yes and that doesn't work



Care to elaborate?

Runtime error 438 object doesnt support this property or method

Originally Posted by xlnitwit

Hi,

A MailItem does not have an Attachment property. You must use .Attachments.Add with the full file path and name.

Yup allready tried that

Please Login or Register  to view this content.

Omg thank you solved