Notifications
Clear all
VBA & Macros
9
Posts
2
Users
0
Reactions
110
Views
Topic starter
Hi, my modified Send Email code for Weekly mail gives me error.
What can be wrong?
Posted : 22/03/2023 10:18 am
That's pretty hard to answer without seeing any of your code. 🙂
Posted : 22/03/2023 11:38 am
Topic starter
Password: 94269426
Posted : 23/03/2023 3:12 am
Your pivot table's data source is set to a blank range, so you can't refresh it.
Posted : 23/03/2023 9:03 am
Topic starter
Hi Velouria.
What do you mean by that, and why does it work for Daily and not for Weekly?
Posted : 24/03/2023 3:14 am
In the sample you posted it does work for weekly but not for daily because the daily pivot table is blank. Its data source is set to 'Station Data'!$Q$1:$AF$48 and there is no data there.
Posted : 24/03/2023 5:50 am
Topic starter
This is the Bug i get when i Run Weekly Email
Posted : 24/03/2023 10:42 am
What is the actual error message? I did't get any errors with that one.
Posted : 25/03/2023 11:56 am
Topic starter
Normal bug 4001
and then the line in the code as in the attached photo above is the error!
Posted : 28/03/2023 2:20 am
