SQL IN OUTLOOK

[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.

 

[Hollis D. Paul]

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.

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

 

[Guest]

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..

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.

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

 

[Hollis D. Paul]

Is there any way of using SQL? I didn't see the
SQL part in the pages you wrote..

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

 

[Guest]

I don't think I have SQL server. Can I use something else?

Is there any way of using SQL? I didn't see the
SQL part in the pages you wrote..

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

 

[Hollis D. Paul]

I don't think I have SQL server. Can I use something else?

Access or Excel both work with Outlook.

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