macro to save worksheet to pdf then email it same time

[Skitzman]

I have excel 2013 and I am trying to become a little more efficient when I use my sheet. whenever I order materials for a job I have to print out 2 copies both in pdf form then run them down to my purchaser and shipping dept manager, I spoke to them both and they said me emailing it to them would work. I want to have a button on my PO sheet that I click and it saves the worksheet as a PDF then emails it to them both. Could If get some direction on how to make the macro It would be very appreciated. I have it close now but it sends the worksheet in excel form not the PDF form. I have a shape button I inserted I will assign my macro to the button.

[tim201110]

i've done that so

[PFDave]

Another option

Please Login or Register  to view this content.

[Skitzman]

its working like I wanted it to. Thank you very much for the help and fast reply.

[Skitzman]

here you go let me know if it works for you. thank you

[PFDave]

Can anyone help on why this part is not working all the time when changed.

I have it working in an example file but it doesn't work all the time which is confusing

Please Login or Register  to view this content.

the error appears in line

Please Login or Register  to view this content.

when trying to attach.

Basically we're looking to change the PDF file name to just be the sheet name.

[Skitzman]

Basically all I want the code to do is save the PDF the name on the tab instead of the worksheet name. Any help would be very much appreciated.

[Pepe Le Mokko]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

http://www.excelguru.ca/forums/showt...pen-in-outlook

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[Skitzman]

This has been resolved and works like a charm. I want to thank anyone who helped me with this.