PDF attachment to email

Hi All

I have a problem with adding an attachment to an email . It's been driving me mad for days.

I can create the email no problem but the email is just a part of a macro which saves a sheet from the workbook to pdf and sends it to a folder and then clears the form for the next entry. The problem I'm having as attaching the saved pdf to the email. I've tried every combination of address for the file imaginable without success to create the attachment. I've added the code to see if anyone can see where I'm going wrong. I've left my last attempt at the address in the .Attachments line for you to see

Kind regards

Paul

Please Login or Register  to view this content.

Hi Paul,
Please refer to this thread.
http://www.excelforum.com/excel-prog...ml#post3148447
I was helped by JBeaucaire
It may help
Kind regards

You may try:

Please Login or Register  to view this content.

Hi All

I've just been going through your replies, I can see how they are supposed to work . I've tried your code Izandol as it was the easiest to implement. But it still will not add the attachment???

I noticed in your code Sean an item:

Please Login or Register  to view this content.

Could this be what is missing from my code? Or could it be something in the settings? I'm running on widows 8.1 and office 2013

Regards

Paul

Does the value in cell AE1 have the ".pdf" extension included?

The value in cell AE1 of the Ofgem Report sheet is just the job number. It is imported (via a linking formula from the input sheet of the same workbook)

it is added to the file name for identification and into the email for reference.

I suggest you change one line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

If there are still errors, remove the On Error Resume Next line and try to run the code again.

Your pathing is probably written incorrectly.

Please Login or Register  to view this content.

Hi Izandol

You are a genius!! worked perfectly

For future reference for everyone here is the final code.

This code does the following:

Saves the sheet to a folder as a pdf. with the correct file name (this is the job number in AE1)

It then creates an email with the correct Reference in the Subject field and adds the reference to the content of the email

It attaches the pdf to the email

It clears the entry sheet ready for the next input.

Thanks to everyone for their help

Kind regards

Paul

I have one more thing that I'd like to achieve with this workbook but it's a different subject so I'll put it in another post

Please Login or Register  to view this content.

Final message

how do i mark this as solved?

According to the Forum Rules:

Click Thread Tools above your first post, select "Mark your thread as Solved"