Access Form from outlook?

Status
Not open for further replies.
E

Edward

Hey all, long time reader, first time poster here :) (cliche intended)

OK, so i have a custom program in the works to organize our emails by

"project". One of my missing links is to hook emails from outlook into

the MDB file.

Here it is very simply: User has outlook open, they select the email

they want, click a button and a small form with a dropdown box pops up

containing the names of our active projects. I want them to select the

project which relates to the email and click OK.

When they click OK, i would like the email to attach itself to a table

in Access.

Is this possible?

Thanks!

Edward
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Yes, it is. For the form I'd use an MSForm, which you can add to the VBA

project. For writing your data into the Access database I'd use the ADODB

library: Add a reference to it via Tools/References, select the newest

available "Microsoft ActiveX Data Objects..." library.

Best regards

Michael Bauer

Am Mon, 17 Aug 2009 13:40:29 -0700 (PDT) schrieb Edward:


> Hey all, long time reader, first time poster here :) (cliche intended)

> OK, so i have a custom program in the works to organize our emails by
> "project". One of my missing links is to hook emails from outlook into
> the MDB file.

> Here it is very simply: User has outlook open, they select the email
> they want, click a button and a small form with a dropdown box pops up
> containing the names of our active projects. I want them to select the
> project which relates to the email and click OK.

> When they click OK, i would like the email to attach itself to a table
> in Access.

> Is this possible?

> Thanks!
> Edward
 
E

Edward

On Aug 18, 3:06 am, "Michael Bauer " <m...@mvps.org
wrote:
> Yes, it is. For the form I'd use an MSForm, which you can add to the VBA
> project. For writing your data into the Access database I'd use the ADODB
> library: Add a reference to it via Tools/References, select the newest
> available "Microsoft ActiveX Data Objects..." library.

> > Best regards
> Michael Bauer

>   >   >  

> Am Mon, 17 Aug 2009 13:40:29 -0700 (PDT) schrieb Edward:

>
> > Hey all, long time reader, first time poster here :) (cliche intended)

>
> > OK, so i have a custom program in the works to organize our emails by
> > "project". One of my missing links is to hook emails from outlook into
> > the MDB file.

>
> > Here it is very simply: User has outlook open, they select the email
> > they want, click a button and a small form with a dropdown box pops up
> > containing the names of our active projects. I want them to select the
> > project which relates to the email and click OK.

>
> > When they click OK, i would like the email to attach itself to a table
> > in Access.

>
> > Is this possible?

>
> > Thanks!
> > Edward-




Michael, thanks for the reply. I added the reference and am trying to

work my way through how this is going to work now. My hope is to just

have the MDB file out on the network somewhere and connect to it in

the background (ie, not have access open) to add the messages.

Do you know if attachments will go along with the email or will I need

a seperate logic for that?

Thanks again,

Edward
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
If you store the email as *.msg file in your db, it will also contain the

attachments.

Best regards

Michael Bauer

Am Wed, 19 Aug 2009 07:54:50 -0700 (PDT) schrieb Edward:


> On Aug 18, 3:06 am, "Michael Bauer " <m...@mvps.org
> wrote:
> > Yes, it is. For the form I'd use an MSForm, which you can add to the VBA
> > project. For writing your data into the Access database I'd use the ADODB
> > library: Add a reference to it via Tools/References, select the newest
> > available "Microsoft ActiveX Data Objects..." library.
>

>> > > Best regards
> > Michael Bauer
>

>>   >>   >>  
>

>> Am Mon, 17 Aug 2009 13:40:29 -0700 (PDT) schrieb Edward:
>

>
>>
> >> Hey all, long time reader, first time poster here :) (cliche intended)

> >
> >> OK, so i have a custom program in the works to organize our emails by
> >> "project". One of my missing links is to hook emails from outlook into
> >> the MDB file.

> >
> >> Here it is very simply: User has outlook open, they select the email
> >> they want, click a button and a small form with a dropdown box pops up
> >> containing the names of our active projects. I want them to select the
> >> project which relates to the email and click OK.

> >
> >> When they click OK, i would like the email to attach itself to a table
> >> in Access.

> >
> >> Is this possible?

> >
> >> Thanks!
> >> Edward-

>

>


> Michael, thanks for the reply. I added the reference and am trying to
> work my way through how this is going to work now. My hope is to just
> have the MDB file out on the network somewhere and connect to it in
> the background (ie, not have access open) to add the messages.

> Do you know if attachments will go along with the email or will I need
> a seperate logic for that?

> Thanks again,
> Edward
 
A

ababer

Edward;455836 Wrote:
> Hey all, long time reader, first time poster here :) (cliche intended)

> OK, so i have a custom program in the works to organize our emails by
> "project". One of my missing links is to hook emails from outlook into
> the MDB file.

> Here it is very simply: User has outlook open, they select the email
> they want, click a button and a small form with a dropdown box pops up
> containing the names of our active projects. I want them to select the
> project which relates to the email and click OK.

> When they click OK, i would like the email to attach itself to a table
> in Access.

> Is this possible?

> Thanks!
> Edward


Hi Edward I am trying to get something similar working, I need to put

emails into a access database table when the send button is clicked.

Do you have this working, if so please can you give some advice.

Andy

ababer

----------------------------------------ababer's Profile: userid=789
?t=126173
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G Adding a contact to Outlook with a custom form using Access VBA Outlook VBA and Custom Forms 1
M open outlook calendar from an access form Using Outlook 4
M open outlook contacts in access 2007 form Using Outlook 1
D "Outlook has blocked access to this form template file. Outlook VBA and Custom Forms 3
B Outlook 2007 form into access field format Outlook VBA and Custom Forms 9
J access within outlook form Outlook VBA and Custom Forms 1
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
D populating listbox on custom form from Access Outlook VBA and Custom Forms 7
M Cannot access the Form Editor BCM (Business Contact Manager) 1
P Hyperlink to Access record/Form Outlook VBA and Custom Forms 2
V How do I unblock access to the form template file? Outlook VBA and Custom Forms 1
B Form into access Outlook VBA and Custom Forms 2
J Recover server side rules from OST/PST without access to the server Using Outlook 2
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
V How to add 'Previous Item' and 'Next Item' to the Quick Access Toolbar Using Outlook 1
J Text icon in Quick Access toolbar ? Using Outlook 2
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
klpconsulting Programmatic Access Office 365 Pro Plus & RDS Using Outlook 1
Fozzie Bear Shared Public Folders Access and Use Exchange Server Administration 0
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
Jennifer Murphy Grant R/W (update) access to a friend Using Outlook 3
O The page that you are trying to access cannot be loaded. Using Outlook 0
T Render Outlook emails in MS access as they appear in Outlook Outlook VBA and Custom Forms 2
T Outlook "A program is trying to access Outlook" Using Outlook 3
GregS Can't access archive file Using Outlook 5
J What is the best EntryID format to set on MS Access table Outlook VBA and Custom Forms 3
J No access to a Database BCM BCM (Business Contact Manager) 3
R How can I access my emails from corrupt offline files of MS Outlook ? Using Outlook 1
V Change default default save location to Quick Access Using Outlook 1
R Quick Access view in File Explorer when saving attachments Using Outlook 0
D Disable or hide "reply" and "reply to all" and "forward" in email from access vba Outlook VBA and Custom Forms 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
O Synchronize safe persons Outlook 2016 -> Outlook Web Access (OWA) Using Outlook 30
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
R Categorize Button in Quick Access Toolbar Disappears on New Email Using Outlook 1
O Outlook Web Access - how to disable spam filter Using Outlook 6
T Lost access to remote BCM database BCM (Business Contact Manager) 4
F Outlook 2016 bulk email from access Outlook VBA and Custom Forms 3
J Programmatic access grayed out Using Outlook 10
Diane Poremsky Synchronize Quick Access Toolbar and Ribbons? Using Outlook 0
G Can't open .pst. Message could not access default folder (Outlook 2010 (.pst). Before that was backi Using Outlook 0
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
T Cannot access outlook.com accounts in Outlook 2016 Using Outlook 1
B Can't expose sender email address when linking outlook to access Using Outlook 3
Diane Poremsky Change Outlook's Programmatic Access Options Using Outlook 0
S how to access the properties of a contact given distlist.member object Outlook VBA and Custom Forms 1
C OWA External Access - No URL / URL Invalid Exchange Server Administration 2
C Merging Word and Access into Outlook Using Outlook 4
I Outlook 2016 and Slow access to Outlook.com IMAP Using Outlook 0

Similar threads

Top