I'm conversant with VBA for Excel, MUCH less conversant for Outlook, so need some hand holding.
At work, each morning, I have 2-6 vouchers bomb due to bad coding by someone in Accounting. We have Budget Analysts around the state to advise Accounting when they have issues. Part of my job is to supply the pertinent Budget Analyst with the details on the problem and the voucher so that they can advise Accoutning on how to recode the voucher to pass. To help me in that, I created the below code. It creates the email shown in the attachment, quick and easy. My problem is that my code is not robust enough; if I have more than one voucher erroring I have to do a lot of typing just to notify my folks that they have issues to look into. Every day the voucher numbers go up, and the format of the numbers changes (for instance,"09670500" is shown in my code, but we're up to 09680423 today, and some vouchers are formatted as "EN0008792", or "CT0006781"). As well, the error might be any of 7 different errors, and I might have to email 3 or 4 different budget analysts. I'd like to do all of that at one shot. To do that, I thought about using a form to plug in the following:
Number of vouchers erroring
(depending on the above, I'd like fields to enter the following for every voucher that's erroring)
Voucher Number
Current coding - 4 fields: Dept (like "010"), PAC (like "11002"), LBBAcct (like "L2005"), and FY (like "2014")
Type of error
Budget Analyst Name (which I would use to pull their email address).
Number of vouchers erroring for that budget analyst today (so we can use text that says "vouchers are erroring" instead of "voucher is erroring")
Note: If LBB Acct is "L2005A" I'd need to add some special standard text to the email notice, for instance "L2005A should never be used".
Once all fields are filled in, I'd like to hit my "Go" button and have an email generated, either one big one to all of the BA's affected by today's erroring vouchers, or a separate email to each one. However, my paltry skill at Outlook programming leaves me virtually helpless here, so I'm here begging for some help.
Thanks in advance!
Bookmarks