• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1649
  • Last Modified:

Email Database Attachments

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
mekah
Asked:
mekah
  • 5
  • 3
  • 2
1 Solution
 
Andrew_WebsterCommented:
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
 
mekahAuthor Commented:
Access 2007, Format is .pdf and they are stored in a normal "Attachment" data type in the table.
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Andrew_WebsterCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
Try this, (it is a accde file) and tell me if it performs the way you desire...
Access-EEQ26855303ExtractAndEmai.accdb
0
 
mekahAuthor Commented:
Yes this is exactly what I am looking for. But you have the database locked down and I can't see the code.
0
 
Jeffrey CoachmanMIS LiasonCommented:
0
 
mekahAuthor Commented:
Thanks for your help
0
 
Jeffrey CoachmanMIS LiasonCommented:
...and thank you for an interesting and thought provoking question

;-)

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now