Sarah has attended:
Excel VBA Intro Intermediate course
Access Advanced course
Access Intermediate course
Create a button to do a number of functions
I want to create a button on a form that does a number of functions.
1) to run a query (the query is already setup, it basically selects all records in one table for a given time period which the user enters)
2) the data is saved as an excel/csv file
3) and then inserted into an open email
Can this be done or am I getting too complicated?
Thanks,
Sarah
RE: Create a button to do a number of functions
Hi Sarah, thanks for your query. Thank can certainly be done but the first question is whether you want to do this from within Access or Excel? Either way, you are going to need code to contact the Outlook object model which is something we do on our Advanced course and is a bit beyond the scope of this forum. However, have a look at this link for pointers on how to export from Access to a csv file:
http://social.msdn.microsoft.com/Forums/en/isvvba/thread/d5432b8e-08f6-4b6a-b13d-fc7656970704
Hope this helps,
Anthony
RE: Create a button to do a number of functions
Hi
I've completed the Advanced course and didn't come across the Outlook Object - I guess it depends on the trainer and the trainees as to whats covered on the day.
I'll see if I can give it a whirl.
Thanks,
Sarah
RE: Create a button to do a number of functions
Oh and I'm wanting to do this in Access
RE: Create a button to do a number of functions
Hi Sarah. We address connecting to Outlook on the Advanced Excel VBA course, not the Access course, which is why you may not have come across it. Here are two links, the first with a good suggestion on linking an Excel CSV file as a table in Access and then running an append query to it:
http://bytes.com/topic/access/answers/868486-export-query-result-csv-file
...and the second discussing emailing from within Access VBA:
http://www.ozgrid.com/forum/showthread.php?t=89441& ;page=1
Hope this helps,
Anthony
RE: Create a button to do a number of functions
Hi,
I've managed to do it using the macro facility.
I basically selected 'Open Query', followed by 'Send Object' then 'Close' and it works perfectly - I didn't even have to write any code.
Thanks for the links they were very helpful.
Sarah
RE: Create a button to do a number of functions
Excellent! The simplest solution is always the best. Glad to be of help.
Anthony
