SQL IN OUTLOOK

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

I under stood that there is no way of using sql statements in outlook.
Is there any way of using queries in OUTLOOK? I need to take one record out
of many (in access DB) according to the email address that is in OUTLOOK.

thanks,
Yonina.
 
I under stood that there is no way of using sql statements in outlook.
Is there any way of using queries in OUTLOOK? I need to take one record out
of many (in access DB) according to the email address that is in OUTLOOK.
Click to expand...
Take a look at these pages:

Connecting Outlook and Exchange to Databases
http://www.outlookcode.com/d/database.htm

Import and Exporting Data from Custom Microsoft Outlook Forms
http://www.outlookcode.com/d/customimport.htm

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA
 
I am able to read a field from a table and copy it into outlook, but I want
to sort it and have queries. Is there any way of using SQL? I didn't see the
SQL part in the pages you wrote..



Hollis D. Paul said:
I under stood that there is no way of using sql statements in outlook.
Is there any way of using queries in OUTLOOK? I need to take one record out
of many (in access DB) according to the email address that is in OUTLOOK.
Click to expand...
Take a look at these pages:

Connecting Outlook and Exchange to Databases
http://www.outlookcode.com/d/database.htm

Import and Exporting Data from Custom Microsoft Outlook Forms
http://www.outlookcode.com/d/customimport.htm

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA
Click to expand...
 
Is there any way of using SQL? I didn't see the
SQL part in the pages you wrote..
Click to expand...
Well, you can access an SQL database just like any other database. But
there is no wizard-based SQL query builder in Outlook that I know of.
Your best bet is to build your query as a stored procedure in SQL
server, and call the stored procedure from Outlook.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA
 
I don't think I have SQL server. Can I use something else?


Hollis D. Paul said:
Is there any way of using SQL? I didn't see the
SQL part in the pages you wrote..
Click to expand...
Well, you can access an SQL database just like any other database. But
there is no wizard-based SQL query builder in Outlook that I know of.
Your best bet is to build your query as a stored procedure in SQL
server, and call the stored procedure from Outlook.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA
Click to expand...
 
I don't think I have SQL server. Can I use something else?
Click to expand...
Access or Excel both work with Outlook.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA
 
Back
Top