Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-12-2019, 11:20 AM   #1
MiscAlma
Newly Registered User
 
Join Date: Jul 2019
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
MiscAlma is on a distinguished road
Is a query like this Possible

I want a button to be able to able to run 3 different queries (Already Done)

After that copy the tables and put the tables in a ms outlook email Ready to be send

is all this possible from 1 button?

MiscAlma is offline   Reply With Quote
Old 07-12-2019, 11:36 AM   #2
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 858
Thanks: 10
Thanked 177 Times in 168 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Is a query like this Possible

maybe OutputTo will work for you
https://docs.microsoft.com/en-us/off...docmd.outputto

or

sendobject
https://docs.microsoft.com/en-us/off...sendobjecttype
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
The Following User Says Thank You to Micron For This Useful Post:
MiscAlma (07-12-2019)
Old 07-12-2019, 11:44 AM   #3
MiscAlma
Newly Registered User
 
Join Date: Jul 2019
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
MiscAlma is on a distinguished road
Re: Is a query like this Possible

Thank you very much I found out about the email macro but I wanted the three reports to be send together!

MiscAlma is offline   Reply With Quote
Old 07-12-2019, 11:51 AM   #4
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 858
Thanks: 10
Thanked 177 Times in 168 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Is a query like this Possible

Quote:
I want a button to be able to able to run 3 different queries (Already Done)
After that copy the tables and put the tables in a ms outlook email Ready to be send
You said nothing about a report. It sounded like you were going to run 3 action queries then send the tables with the changes.

I have no code handy for this, so the best I can do is offer at least 1 result from a 10 second search that has at least one method. Probably someone will chime in with their version, but there is ready made code at that link.
Micron is offline   Reply With Quote
Old 07-22-2019, 11:38 AM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,930
Thanks: 13
Thanked 1,527 Times in 1,453 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Is a query like this Possible

You can do anything you want with code. Use three TransferText commands to export the three queries to separate sheets of the same Workbook. Then use the Output to email the spreadsheet you just created.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 02:17 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World