Solved

Email Database Attachments

Posted on 2011-03-01
10
1,264 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
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

776 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