Solved

Email Database Attachments

Posted on 2011-03-01
10
1,420 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
Industry Leaders: 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!

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

688 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