rsilberfarb
05-19-2005, 04:43 PM
Not sure if this is the right forum, but here goes:
I already have code in place to do the following:
When an e-mail comes in from a particular sender, save it as text and automatically open an Excel file that imports the text and populates a form. Then the form is automatically sent to an e-mail address.
What I need to add:
I have an access database to keep track of the form info. Within the Excel file is a sheet that has info that I manually import into the database utilizing a "transfer spreadsheet" macro connected to a switchboard button. So currently I need to manually click the button to get the info into the database. I would like this step to happen in conjunction with what I already have automated
Any ideas are welcomed.
Thanks in Advance!!!!
Ross
I already have code in place to do the following:
When an e-mail comes in from a particular sender, save it as text and automatically open an Excel file that imports the text and populates a form. Then the form is automatically sent to an e-mail address.
What I need to add:
I have an access database to keep track of the form info. Within the Excel file is a sheet that has info that I manually import into the database utilizing a "transfer spreadsheet" macro connected to a switchboard button. So currently I need to manually click the button to get the info into the database. I would like this step to happen in conjunction with what I already have automated
Any ideas are welcomed.
Thanks in Advance!!!!
Ross