Is there a white paper on my following need. I did not see one. Probably missed it.
I have an Access 2003 report. After i run the report, i do an Export to a certain directory as an HTML format.
I would like the html to attach to an Outlook screen for sending it with an email note.
The recipient would load up my Html file into Excel. For some reason, my report has to be an html and not sent as an excel file. i lose alot of formatting if i had sent it as an excel sheet.
Is there somewhere that i can learn how to do this routine by having the vba code inside a Form button.
i can do all of this manually, step by step. however, i would like to have one Access form button do all of this routine.
thanks molly
I have an Access 2003 report. After i run the report, i do an Export to a certain directory as an HTML format.
I would like the html to attach to an Outlook screen for sending it with an email note.
The recipient would load up my Html file into Excel. For some reason, my report has to be an html and not sent as an excel file. i lose alot of formatting if i had sent it as an excel sheet.
Is there somewhere that i can learn how to do this routine by having the vba code inside a Form button.
i can do all of this manually, step by step. however, i would like to have one Access form button do all of this routine.
thanks molly
