Search results

Thank you very much Chris! Your skeleton VB code is almost perfect! There is a few questions however. 1) Is there a way to say the file in Excel format and then ZIP it before it e-mailed out? 2) The E-Mail Subject is not going to change except for the Fiscal Week number for example, "Here...

Well, I can make the table as you specified with no problem. Writing the code, I simply do not know how to do at all. If you don't mind and could give me some direction or even paste example code of what are trying to explain so that I incorporate it would be nice. Just saying to write code...

Thank you Rich! That helps quite a bit, however I may have not come across as clear as I needed to. I have a Macro which is setup to Open a Query, then output it to file in Excel format. Then it opens another query and also outputs it to an Excel file. This goes on for about 70 different...

I have this database in Access 200 where it opens various queries and then outputs them to a file in Excel format on a datashare. The problem is that I have to update the filenames in the "Output to" section in the macro everytime I have to run it to correspond to the Fiscal Year the report is...

That's just the thing. The Data hasn't yet been stored. Its kinda floating until I add the record. If I have to add the record first, then how will it know what record to pull the data from to send the e-mail?

BTW, I'm using Access 2000 SR-1. Thank you.

Ok. I have a pretty good sense on using Access, but I have a question that has been baffling me. I have a main form with a few subforms and want to be able to a have a button that will e-mail a specific person or department with the details of the data in the form before the form is written...