How to save a file with unique name, export specific range to pdf and email to specific addresses with specific heading and body text.

[davellc]

Hello,

I have taken on a new role and have never used VBA before. I can absolutely see that using VBA to automate some of the more repetitive tasks my new team do would be a great thing for me to do.
There is so much information on these and other boards and sites that putting together what I would like to do has become total overload so I though I would ask everything together in the hope that someone would be able to give me a working example.
Where I have taken things from various sites, it have run into issues I cannot solve.

So here goes.
I would like my team to be able to automatically:
From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followed by the contents of cell A1 and the time now in hour and minute format"
From a second button: export a specific range within a sheet in that new file to a pdf of the same name and it be automatically emailed to a specific group of addresses with a preset title and preset text in the body of the email.
From a third button send a specific sheet

in that new file to a pdf of the same name and it be automatically emailed to a specific group of addresses with a preset title and preset text in the body of the email

Thanks in advance.​

 

[John_w]

Welcome to MrExcel forums.

Button 1 - record a macro whilst you save the .xlm file in the required location with a dummy file name. The code can be edited to instead save the file with the required name.

Button 2 - see https://www.mrexcel.com/forum/excel-questions/1050226-vba-how-can-i-email-range-pdf.html

Button 3 - see https://www.mrexcel.com/forum/excel...pdf-instead-xlsx-post4351104.html#post4351104