?
Solved

Email Database Attachments

Posted on 2011-03-01
10
Medium Priority
?
1,475 Views
Last Modified: 2012-05-11
Maybe I should know how to do this but can't seem to get my head around it. All I want to do is be able to E-mail all my attachments that are stored in one field in my database. Evey thing I look up on the internet show me how to e-mail external Attachments but that is not what I need. Can someone help please. I don't mind it it's Macro or VBA.

0
Comment
Question by:mekah
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
10 Comments
 
LVL 8

Expert Comment

by:Andrew_Webster
ID: 35007920
Give us a little more information.  What format attachments are they?  How have you stored them (I'm assuming as BLOBs)?  Which version of Access?

I don't know an answer off the top of my head, but it's a great question, so if I can find time today I'll research it some.
0
 

Author Comment

by:mekah
ID: 35008421
Access 2007, Format is .pdf and they are stored in a normal "Attachment" data type in the table.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35008481
There is no "Direct" way to email "Attachment Field" files into an email, through MS Access.

This is perhaps yet another reason why you should "Link" to external files, and not "Store" them in the database.

As Andrew says, this is an interesting Question, ...perhaps another Expert can come up with the code to Extract the Attachment Datafiles...

JeffCoachman
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 8

Expert Comment

by:Andrew_Webster
ID: 35011721
Ok, I had ten minutes to look at this then work interupted!

What I worked out was that it's a two step-process.
1. Extract the BLOB to a file
2. Automate Outlook to then create an email, add the attachment, and scoot it off.
(3. Optionally, then delete the exported file.)

More than that, I'm sorry, I'm in a time crunch at work so I've not managed to get any further.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35012196
Well there is no specific "Email Access Attachment Datatype fields" direct code.
This has to be coded in steps, as Andrew hints at

You are also not specific enough as to what *Exactly* you want...

Email all attachments in one email or multiple emails? (One email for each attachment record?)
Email to who?  Is the email address in the record, or will you be typing it in for each record's email?
What is your skill level at VBA?

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35014718
Try this, (it is a accde file) and tell me if it performs the way you desire...
Access-EEQ26855303ExtractAndEmai.accdb
0
 

Author Comment

by:mekah
ID: 35015194
Yes this is exactly what I am looking for. But you have the database locked down and I can't see the code.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 35017346
0
 

Author Closing Comment

by:mekah
ID: 35024913
Thanks for your help
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35030203
...and thank you for an interesting and thought provoking question

;-)

Jeff
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question