Attachments.Add error

[DanielHansen]

Hello.

I've tried to make an macro which will send an email with an attached PDF from my spreadsheet.

So far so good I've managed to make it work, but for some reason it will now crash and give the highlighted error on .Attachments.Add Fname, where it tells me that the path doesn't exist or wasn't found. The only problem is, that the exact same macro just created that PDF, but in the same macro it tells me it doesn't find the path.
If I remove the Attachments.Add Fname the macro manage to send the email correctly just without my PDF.

In VBa it looks like this:

Please Login or Register  to view this content.

Hope that anyone can help me out here.

Daniel

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

For Attachments.Add you will need to use the full pathname of the file, not just the file name. Where are you saving the PDF file when you create it?

[DanielHansen]

What would the code tag be in this case?

How can I put in the full path name, when the macro will create the file on the saving location? And the file names will change every time according to the data in the spreadsheet. The location can be changed but I’ve tried this with different saving-location when you go to Options > Save