Hey,
Here is my situation. I have queries that displays email addresses of our employees in each department. Due to employees leaving from time to time, these queries are updated regularly to accomodate for those changes. I also have a large Email Contact workbook in Excel with each department having its own worksheet tab.
What I have been doing is creating an Export macro in Access and using the Transfer Spreadsheet action to export each query to its own excel spreadsheet into a directory. Then I would paste the updated results into the email contact workbook.
Is there an easier way to export the query results into the corresponding tab in the existing excel workbook, updating/overwriting the old data?
If you need more information, let me know.
Thanks