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. .
 
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.
< Reminder not displayed because folder does not support reminders | Install Macro >
Similar threads
Thread starter Title 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
L Opening People Outlook 2021 Using Outlook 2
U When opening shared Calendar "The set of folders cannot be opened" Using Outlook 0
KurtLass Opening Graphics Attachments in Outlook 2021 Using Outlook 0
Witzker Place cursor at opening, a user defined OL contact form Outlook VBA and Custom Forms 3
A OutLook For Mac 16.46 Comes Up In Small Window When Opening Using Outlook 4
U Disable "Always ask before opening" Dialog Using Outlook 3
Wayne Outlook locks up when opening "Manage Rules & Alerts" Using Outlook 7
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 Using Outlook 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 Using Outlook 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

Similar threads

Back
Top