Qrackerman
Registered User.
- Local time
- Yesterday, 20:46
- Joined
- Oct 17, 2002
- Messages
- 34
Can the output of a query be e-mailed to someone and then be able to use the query in their db. without sending the entire .mdb file?
E-mail Query
- Thread starter Qrackerman
- Start date
Robert Dunstan
Mr Data
- Local time
- Today, 01:46
- Joined
- Jun 22, 2000
- Messages
- 291
Hi there
I don't think you can e-mail objects as they are i.e. a query as a query. You can e-mail the results by using the SendObject action.
If you need to e-mail the structure of the query then, providing your recipient has exactly the same .mdb as you, why not import the query into a new blank database and e-mail that. All they would have to do at the other end is to import that query into their copy of your .mdb
HTH
Rob
I don't think you can e-mail objects as they are i.e. a query as a query. You can e-mail the results by using the SendObject action.
If you need to e-mail the structure of the query then, providing your recipient has exactly the same .mdb as you, why not import the query into a new blank database and e-mail that. All they would have to do at the other end is to import that query into their copy of your .mdb
HTH
Rob
FoFa
Registered User.
- Local time
- Yesterday, 19:46
- Joined
- Jan 29, 2003
- Messages
- 3,672
If it is the OUTPUT of a query, than Robert Dunstan has it right, but if it is the query itself, you can just Email the SQL and they can paste it in a query. Of course they have to have the same table structure/names etc.
