VBA – Merge Workbooks As Worksheets

An the accounting department of an insurance company had daily financial reporting that was automated by their IT department providing daily reports to a network drive for seven software systems.  7 software systems x 30 working days per month = 210 individual files.  Each of these files, per software system, needed to be opened as … Read more

VBA – Count emails on a date

Planning for support desks isn’t easy.  Support request volumes adjust with month-end, billing and payment cycles, holidays, etc.  Phone call volumes are usually pretty easy to find.  Emails — not always so easy.  That’s why there’s this little script.  Navigate in Outlook to the folder you want to count (maybe the inbox or archives of … Read more

VBA – Loop through files and attach each one to a new email

The situation that was brought to me was that a folder existed on a desktop that had approximately 100 pdf files.  These files all needed to be emailed out as monthly billing statements.  These were only the ones that were not billable through EDI or some other method. Here are the rules: For every pdf … Read more