First, let me say that VBA is not my strong point but I have been bestowed with creating a duplicate database of a former employee who sabotaged the original. And everyday this isn't working is creating a ton of manual work for other people. I have managed to get the entire database working with the exception of the final step.
Basically, you click three buttons, the first button imports many text files using the Open File Dialog window and shift key, sorts, manipulates and adds needed information to the line items. They are payments to customer accounts.
The final step used to be to click on a button and an Outlook New Mail Message window would pop up with a specific email distribution list in the To: Box, the email body was a nice looking summary (which I know originated from a report in Access and I have duplicated the report) and then automatically attached an excel document with all the data details (which I have also duplicated the excel doc). There was one week where I ran this database for him while he was out of the country and the document it attached would export to my desktop during the initial run of the data and I could delete it after the email was sent.
Long story short, my reports are called rpt_PaymentUplo adData1 and rpt_PaymentUplo adData2. There was one button for each email. They both go to different distribution lists but if I can figure out how to do one then the other will just be a copy with a few modifications.
I know this is asking a lot but does anyone have an example of something similar to what I speak of? I have searched many forums and do not know enough VBA to make this type of action work. I only understand about 20% of the VBA code the rest might as well be in another language. I have a course in February that should help me going forward but until then I am lost. Any ideas or pity out there on the Interweb?
Basically, you click three buttons, the first button imports many text files using the Open File Dialog window and shift key, sorts, manipulates and adds needed information to the line items. They are payments to customer accounts.
The final step used to be to click on a button and an Outlook New Mail Message window would pop up with a specific email distribution list in the To: Box, the email body was a nice looking summary (which I know originated from a report in Access and I have duplicated the report) and then automatically attached an excel document with all the data details (which I have also duplicated the excel doc). There was one week where I ran this database for him while he was out of the country and the document it attached would export to my desktop during the initial run of the data and I could delete it after the email was sent.
Long story short, my reports are called rpt_PaymentUplo adData1 and rpt_PaymentUplo adData2. There was one button for each email. They both go to different distribution lists but if I can figure out how to do one then the other will just be a copy with a few modifications.
I know this is asking a lot but does anyone have an example of something similar to what I speak of? I have searched many forums and do not know enough VBA to make this type of action work. I only understand about 20% of the VBA code the rest might as well be in another language. I have a course in February that should help me going forward but until then I am lost. Any ideas or pity out there on the Interweb?
Comment