Markus,

As I have mentioned earlier that it is basically a gmail account that i am trying to configure and it is accessible form that machine. I am able to send...

kathi,

This option is checked in the outlook.

nomi

AJ ,

your soultion doesn't work.

nomi

kenneth

u have hit the nail on the head, it works, thanks a lot for ur help

nomi

i am having the problem with this column: 'address_name'

You are right there is an outer join, Here is the definition of the view:

SELECT

1 'company_code',

RM2.CUSTNMBR 'customer_code',

RM2.ADRSCODE 'ship_to_code',

RM1.CUSTNAME 'address_name',

RM1.SHRTNAME 'short_name',

RM2.ADDRESS1 'addr1' ,

RM2.ADDRESS2 'addr2'...

Yes i forgot to do that but u can declate it and initia;lize it with 0. But it doesn't affect the output.

Thanks

nomi