473,494 Members | 2,223 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Generate Reports to Multiple People Automatically - SendObject

I have a table of trucking companies which contains each company's
email address. I need to be able to create a situation where all the
shipments for each trucking company are emailed to them each hour.

My thoughts are that a report that I have written would be generated
based off a null field in the shipment table. The problem is that a
carrier may have a shipment one day and not the next. I want to send
each carrier only their shipments. So how do I automate so that the
database pulls a report for each carrier that has a shipment ready and
then emails to the email address in the trucking company table???
Any assistance would be greatly appreciated.

Thanks in advance.

Nov 13 '05 #1
0 1127

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
7035
by: alessia | last post by:
Hi, i'm sorry for my bad english but ..i'm italian.. I have a big problem that I don't succeed in resolving on the command sendobjet. I have a query that as resulted a list of addresses e-mail it...
0
1231
by: GHJ | last post by:
Is it possible to e-mail multiple reports on the same e-mail using the DoCmd.SendObject acSendReport? Glen
16
48821
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use...
7
12566
by: Mega1 | last post by:
is this possable to send more than 1 report in one email
2
1330
by: Wayne | last post by:
I'm having trouble sending snapshots of reports using SendObject on my desktop machine but the code works fine on my notebook. I don't think that it is a coincidence that "Mailwasher" - a mail...
2
2022
by: Barry Edmund Wright | last post by:
Hi, I have two reports that I want to attach to the same email: rptBugReport rptBugLog I can sent the one using: DoCmd.SendObject acOutputReport, "rptBugReport", acFormatSNP How can I add...
1
2025
by: NeoDeGenero | last post by:
I have a little VBA/Access - Reports problem and I’m not sure on how to approach it: I am trying to send a Report generated by MS Access via email through the command SendObject. ...
1
2618
by: schlow09 | last post by:
Hey everyone, hoping someone could lend me a hand here... I'm trying to create a button in a form that will automatically send an email with a report. However this report can vary depending on the...
2
9820
iBasho
by: iBasho | last post by:
Hi, I am trying to set up a notification email that would come to my email everytime users click on a command button in a form. I am using the DoCmd.SendObject command without actually sending any...
3
1270
by: freddie1437 | last post by:
Hello everyone, I have a question and I haven't been able to figure it out. I have a database that has all of our safety issues which has primary field Report# and what I am doing is trying to...
0
7119
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6989
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7157
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7195
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6873
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7367
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4579
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3088
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1400
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.