I normally can find what I am looking for in these forums, but this one has me stumped. I need to create a macro to save & send a file in excel 2010. When creating my macros to date I haven't used vba. Here is what I am looking to do:
1. Create a PDF of Cells A1:K16 and create the e-mail
2. If possibly have the Subject of the e-mail read: C1&" "&C2&" "& Cost Tracking
I do not want the e-mail to send, just generate the pdf and e-mail.
1. The only way I can do this manually is to hide all rows under row K, about 100 rows.
2. Go to file, save & send, send PDF
This generates the e-mail, but not the subject, and the rows are still hidden. Ideally when complete the rows would not be hidden, and the e-mail would be generated on the screen.
Any help would be appreciated. When I try to create the macro myself I have no way of ending the sequence as it won't let me end it with the generated e-mail still on my screen.
1. Create a PDF of Cells A1:K16 and create the e-mail
2. If possibly have the Subject of the e-mail read: C1&" "&C2&" "& Cost Tracking
I do not want the e-mail to send, just generate the pdf and e-mail.
1. The only way I can do this manually is to hide all rows under row K, about 100 rows.
2. Go to file, save & send, send PDF
This generates the e-mail, but not the subject, and the rows are still hidden. Ideally when complete the rows would not be hidden, and the e-mail would be generated on the screen.
Any help would be appreciated. When I try to create the macro myself I have no way of ending the sequence as it won't let me end it with the generated e-mail still on my screen.
