Opening an existing message from a database query

Status
Not open for further replies.
J

Jon C

Using an SQL database (and lets say hypothetically MS access) and Outlook 2007.

What is the easiest way to automatically associate an email with the database?

The email subject lines will all be static and contain a USER_ID and MONTH field.

The same USER_ID and MONTH is also present in the database.

Provided both programs are open... Is it best to design a query that pulls the USER_ID and MONTH field out of the database and sends a command to Outlook to open all emails with subject lines that match this USER_ID and MONTH?

I'm open to any suggestions.. What is the best/easiest way to accomplish this automation? Any links provided would be greatly appreciated. .
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
With the Restrict or Find functions you can find items, for instance by

Subject, in a folder. But you need to know the folder or loop through every

possible folder.

An alternative would be to use the StoreID and EntryID. With that, and

provided that the message won't be moved, you can get it with the

GetItemFromID function.

Best regards

Michael Bauer

Am Tue, 18 Aug 2009 19:00:25 -0400 schrieb Jon C:


> Using an SQL database (and lets say hypothetically MS access) and Outlook


2007.

> What is the easiest way to automatically associate an email with the


database?

> The email subject lines will all be static and contain a USER_ID and MONTH


field.

> The same USER_ID and MONTH is also present in the database.

> Provided both programs are open... Is it best to design a query that pulls


the USER_ID and MONTH field out of the database and sends a command to

Outlook to open all emails with subject lines that match this USER_ID and

MONTH?

> I'm open to any suggestions.. What is the best/easiest way to accomplish


this automation? Any links provided would be greatly appreciated. .
>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
S my vbscript button1_click code works on appointment created but not on opening an existing apntmn Outlook VBA and Custom Forms 16
B Outlook 2010 Opening Mail Attachment Using Outlook 2
A Warning When Opening attachment Using Outlook 7
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 2
H Upon opening Outlook, make my popmail inbox open instead of outlook.com inbox Using Outlook 1
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
L What are the risks of opening an Outlook 2016 .pst file in Outlook 2010? Using Outlook 4
D Outlook 2007 crashes when opening an email Using Outlook 2
A Outlook 2016- unable to have all subfolders expanded when opening outlook Using Outlook 11
GregS Immediate crash on opening Using Outlook 3
Diane Poremsky Error Opening Outlook and Control Panel's Mail Applet New Slipstick.com Articles 0
N Wishlist Opening Outlook where we left off Outlook Wishlist 0
J Opening Attachments - in People Using Outlook 2
Mistyfied Outlook 2016 not opening Using Outlook 2
M Update field codes when opening Outlook Template Outlook VBA and Custom Forms 2
R Outlook PST not opening Using Outlook 1
U .pst file error at opening outlook Using Outlook 1
A Problems Opening Excel from Outlook Outlook VBA and Custom Forms 3
Diane Poremsky Disable the Unsafe Hyperlink Warning when Opening Attachments New Slipstick.com Articles 0
S macro for opening attachments and printing Using Outlook 1
Z how to make OL (2007) to use custom contact form when importing / opening .VCF? Using Outlook 1
T Opening email causes "Contacting ..." message Using Outlook 1
K Outlook 2013 stuck "processing" when opening. Using Outlook 3
S Opening Outlook Windows Using Outlook 1
S PoP up reminder while opening the outlook? Outlook VBA and Custom Forms 1
J Opening/Archiving/Import/Export PST files Using Outlook 4
Y (Shared Folder) Using the preview pane to open and close a fax, without opening the email itself Using Outlook 1
E OL2007 on Exchange: opening OL on different computers Using Outlook 1
Z outlook 2007 - opening a contact from the search results doesn't use the custom form Using Outlook 10
T Error opening mail with pictures - "The linked image cannot be displayed" Using Outlook 3
P I'm getting an error when opening Outlook "Mobile me stopped working Using Outlook 1
D opening Word Document in a business contact? BCM (Business Contact Manager) 3
B Contact changes from Personal to Shared when opening custom form Using Outlook 0
C How to stop iCloud calendars opening by default Using Outlook 8
U outlook 2010 freezes/crashes when opening encrypted e-mails Using Outlook 0
G OLMAPI32.dII error prevents Outlook 2010 from opening Using Outlook 2
D Custom Tool Bar and/or Commands do not remain when re-opening Outlook 2007 Using Outlook 3
G opening Outlook again after closing closing? Using Outlook 0
B Outlook 2010: how to mark messages without opening? Eg for deletion Using Outlook 2
M I cannot start Microsoft Outlook 2013 directly opening a .eml message Using Outlook 1
M Opening Word Doc's in Adobe Acrobat Pro Using Outlook 9
L Opening up Contact from an Email - Outlook 2007 Using Outlook 15
0 Outlook 2010 causes computer to lose connection when opening and Send/Receive Using Outlook.com accounts in Outlook 14
G Opening messages takes too long Using Outlook 5
G Opening pst files in different versions of outlook Using Outlook 2
F Default Program for Opening .pst Files ? Using Outlook 6
mrje1 Opening a task the Insert Tab Option is not showing up and organizing Tasks Using Outlook 9
B Two server DAG setup, second server EMC not opening Exchange Server Administration 3
D Outlook 2007 Messages Opening on their own (IMAP) Using Outlook 2
A Password, opening attachment problem Using Outlook 4
Similar threads


















































Top