Hi, I have several reports which export data from Access to Excel overnight. I then have to manually go into each of the spreadsheets and create a pdf file which I then email out each morning. I was wondering if anybody knows of any way that I could automate this part as well so that a macro runs within the spreadsheet which prints the relevant tabs to pdf and then emails the pdf file out to the relevant people?

Thanks in advance,

Ben