Leslie Isaacs
12-31-2004, 03:17 AM
Hello All
I have an MS Access97 mdb that works fine, but I need some help with some new functionality - involving some VBA coding (I think!).
The current form contains fields [client_name] and [client_email_address], plus various yes/no fields (represented as check-boxes) corresponding to various reports. Where the yes/no field is True, the client requires that corresponding report. Currently, a macro prints out the required reports. What I want is to be able to output all the required reports (typically between 4 and 8 reports, out of about 25 'possibles') for the current client, 'stacked' as attachments to a new email opened in Outlook.
Some of the reports would need to be output as excel files - which I have found can sometimes be problematic with regard to layout (i.e. column headings). The rest of the reports could be output as excel files or as any other type most likely to be universally accessable to clients.
Also, it would be extremely useful if one partcular report (one that would need to be output as an excel file) could also have the 'track changes' attribute set (by code) to 'true' - ideally just for columns A to G (all rows) (!). Can that be done?
I should also add that the PCs running the application are running Office97 (under Windows2000 Professional), whereas some of the clients (to whom the excel and other output is to be emailed) will be running Office2000 or later.
I realise that I have a task on my hands, but if someone could point me in the right direction that would be great! Or, if someone would be interested in writing the code for me (obviously for a fee), that would also be great (depending on ther fee!!)
Hope to hear from someone.
Leslie Isaacs
I have an MS Access97 mdb that works fine, but I need some help with some new functionality - involving some VBA coding (I think!).
The current form contains fields [client_name] and [client_email_address], plus various yes/no fields (represented as check-boxes) corresponding to various reports. Where the yes/no field is True, the client requires that corresponding report. Currently, a macro prints out the required reports. What I want is to be able to output all the required reports (typically between 4 and 8 reports, out of about 25 'possibles') for the current client, 'stacked' as attachments to a new email opened in Outlook.
Some of the reports would need to be output as excel files - which I have found can sometimes be problematic with regard to layout (i.e. column headings). The rest of the reports could be output as excel files or as any other type most likely to be universally accessable to clients.
Also, it would be extremely useful if one partcular report (one that would need to be output as an excel file) could also have the 'track changes' attribute set (by code) to 'true' - ideally just for columns A to G (all rows) (!). Can that be done?
I should also add that the PCs running the application are running Office97 (under Windows2000 Professional), whereas some of the clients (to whom the excel and other output is to be emailed) will be running Office2000 or later.
I realise that I have a task on my hands, but if someone could point me in the right direction that would be great! Or, if someone would be interested in writing the code for me (obviously for a fee), that would also be great (depending on ther fee!!)
Hope to hear from someone.
Leslie Isaacs