Hello, I was wondering if anyone knew if there was a way to count how many letters are sent from the sent box by each user per day. So if John Smith sends 10 emails and they are all in the sent box, it would output into Excel something like this when the macro is run:
Any help at all or even starting point would be appreciated so I can maybe try and figure this out on my own but Lotus Notes seems a little hard to work with when interfacing with VBA.
| Book2 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Name | Amount | Date | ||
| 2 | John Smith | 10 | 01/01/2022 | ||
Sheet1 | |||||
Any help at all or even starting point would be appreciated so I can maybe try and figure this out on my own but Lotus Notes seems a little hard to work with when interfacing with VBA.
