Solved

Email Database Attachments

Posted on 2011-03-01
10
1,177 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
 
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now