Sending reporting to email automatically from excel via VBA

Hello,
I would need your help. I do the follow up of cell phone expenses of our company. Every month I have to send to every corporate cell phone user a short reporting of minutes/R$. This reporting is nothing else than just a dynamic table in which I change the filter (name) for each user. Now I do it manually, but I tried to find an automatic way, and found help from my friend, but which still gives me a message of error.

See hereunder the script :

Please Login or Register  to view this content.

I can share the original file, if it helps.

Thanks in advance !Reporting.xlsx.xlsmReporting.xlsx.xlsm

Martin

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires CODE tags. I have added them for you because it's your first post--6StringJazzer

You don't say what the error is, or when it happens. If it is error 400 with no text, and it's when you try to save the temporary file, I think it is because you are trying to save directly onto the C: drive ... which, in my machine, you're not allowed to do. Create a sub-folder, on the C: drive, if you wish, and save and send the temporary file there.


Regards, TMS

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.