Integration of outlook with excel VBA

[Nanimadhu]

Hello Experts,

I'm in search of a VBA macro which will send a mail through outlook automatically with the count of files(.pdf + .msg files) in any given folder.

Let me explain my requirement.

I work for an organization, where we use Outlook for mailing purpose.

Everyday Inventory(.pdf files and .msg files) will be saved in a folder that is to be processed.

I want a macro which should automatically send the total inventory (.pdf files + .msg files) through my outlook mailbox(say: me@outlook.com) to a my superiors outlook mailbox(say: superior@outlook.com).

If the macro sends that email to my superior before me and my superior logon to computers at perticular time (say: 7:00AM daily), it will be of great help to plan our day at work.

Any help will be appreciated.

[Fotis1991]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

[6StringJazzer]

Moderator's note: It appears that this is the earlier thread. The duplicate thread started later that is still open may be found here. --6StringJazzer

[Fotis1991]

so..........?