Email from Query

[emmalj]

Good Morning,

 

I was hoping someone could help me out - I have the task of creating a system for our transport manager and would like to email query results, thing I dont know is what VBA coding i need in order to do this ......

 

Any suggestions would be great, need anymore information feel free to ask?

 

thanks

[theriver]

What is the database platform?

[emmalj]

Sorry its Access 2007

[edutech4schools]

If I understand your question you could simply use Google forms, its free and very easy.

 

http://www.youtube.com/embed/IzgaUOW6GIs

[emmalj]

I would but its a bespoke system and the database is held here at site so using something like google forms wouldn't work unfortunately. But thanks for your feedback.

 

I do have some coding that I could use and a list of tables I want to appear in the emailed query ..... if it helps I can post it to someone?

Edited October 24, 2013 by emmalj