I have a table with pdf files stored in an attachment data type field
in a 2007 Access File. I would like to run a query that would select
a group out of this table (easy part) then send the pdf file stored in
the attachment field in each of the selected records to a specific e-
mail address as an attachment to the e-mail. The pdf files can be
zipped together or left separately.
First off, Is this possible? I haven't found a lot of info on how to
use this field type.
If it is possible can you outline the process for me.
Thanks for the help!
Nick
2  2592 
On Nov 7, 4:43 pm, ndu...@morrisse yinc.com wrote:
I have a table with pdf files stored in an attachment data type field
in a 2007 Access File. I would like to run a query that would select
a group out of this table (easy part) then send the pdf file stored in
the attachment field in each of the selected records to a specific e-
mail address as an attachment to the e-mail. The pdf files can be
zipped together or left separately.
First off, Is this possible? I haven't found a lot of info on how to
use this field type.
If it is possible can you outline the process for me.
Thanks for the help!
Nick
Out Total Access Emailer product supports this, plus a lot of other
features to let you send personalized emails and filtered reports
(including PDF files in Access 2007) to your contacts.
For more information including a fully functional demo, visit http://www.fmsinc.com/Products/Emailer/index.asp
Luke Chung
President
FMS, Inc. http://www.fmsinc.com
On Thu, 08 Nov 2007 05:01:52 -0000, FMS Development Team
<fm****@gmail.c omwrote:
You hit the Send button before inserting a code snippet.
-Tom.
>On Nov 7, 4:43 pm, ndu...@morrisse yinc.com wrote:
>I have a table with pdf files stored in an attachment data type field
in a 2007 Access File. I would like to run a query that would select
a group out of this table (easy part) then send the pdf file stored in
the attachment field in each of the selected records to a specific e-
mail address as an attachment to the e-mail. The pdf files can be
zipped together or left separately.
First off, Is this possible? I haven't found a lot of info on how to
use this field type.
If it is possible can you outline the process for me.
Thanks for the help!
Nick
Out Total Access Emailer product supports this, plus a lot of other
features to let you send personalized emails and filtered reports
(including PDF files in Access 2007) to your contacts.
For more information including a fully functional demo, visit
http://www.fmsinc.com/Products/Emailer/index.asp
Luke Chung
President
FMS, Inc.
http://www.fmsinc.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Leon |
last post by:
I am trying to send an email with an attachment.
The problem is the attachment is stored in db where I have created a
longblob field that contains the file so I have no idea how to specify
the file path when I want to send an email.
I have tried "" and "/" that didn't work.
Any help?
My code is
------------------------------------------------------------------------
|
by: Bill |
last post by:
I am trying to have the capability to email attachments. Specifically
I want to be able to email a specific attachment that I name that may
be a PDF document, text doc, etc. I already have a working piece of
code that emails jpg attachments but does not work with any other
types of attachments. Could someone tell me how to modify this code to
send other types of attachments like the one's stated above(especially
PDF's)? Also how do I...
|
by: Bob-O |
last post by:
Need your help in sending an email message with an attachment in my VB.Net program. Sending a body message is no problem. I don't know how to use the attachment property in an emai
Following is an excerpt from the program
Imports System.Web.Mai
Imports System.Web.HttpServerUtilit
Imports System.Diagnostics
Public Class Emailin
Inherits System.Web.UI Pag
|
by: Pommy_g |
last post by:
Hi, i have done some searching on the newsgroups for this problem but
have had no luck.
Basically i have a query, and what i need is a button that when
clicked on sends an email to whoever, containing the the data from the
query. Then i need the data that was sent, to go into another query
(preferably once the email has actually been sent as opposed to once
the button has been clicked)
Can anyone help out here?
|
by: Colin Anderson |
last post by:
I discovered, with great excitement, this article
http://www.davison.uk.net/vb2notes.asp when researching methods for
emailing from Access via Notes. Unfortunatly, when I run this I get a
Run-time error. When I run it on an XP machine it crashes, but on an
NT box it just generates an unknown error, handled by the error
handler. I have debugged and stepped through the code and have
narrowed the issue to the point at which the...
| | |
by: Farooq Khan |
last post by:
hi,
i'm using CDONTS component for emailing through one of my web service like
this
// Start of code
// 'email' is the CDONTS object name
email.send(EmailFrom.ToString(), EmailTo.ToString(), Subject.ToString(),
Body.ToString(), 1)
|
by: MikeR |
last post by:
Anyone know a group to submit a CDONTS question to?
Thanks, Mike
|
by: bonneylake |
last post by:
Hey Everyone,
Well this is my first time asking a question on here so please forgive me if i post
my question in the wrong section.
What i am trying to do is upload multiple files like gmail does. I found a script that does this on easycfm.com (Topic 13543).
But anyway when i try to upload multiple files it will create multiple records in my database (like it should), but it wont upload multiple files. What ever file i choose to upload...
|
by: =?Utf-8?B?U2FpIFZhamph?= |
last post by:
Hi
I am trying to send a .pdf document as an email attachment using net.mail.
This email is being sent by a windows service application. After i receive
the email, and when i try to open the attachment, i get the following error
message...
"adobe reader could not open <filenamebecuase it is either not a
suppported file type or because the file has been damaged(for example, it was
sent as an email attachment and wasn't correctly...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
