hi, thanks for the tips. but my second part of the question was some thing
like this::

I have an excel sheet with email column, when i click the email address in
that column, outlook compose box is opened using word editor. when i click
send button from there it sends the message to outbox of oultlook and is
closed without asking for credentials.

It is here i want it to ask for some credentials rather than storing it in
outbox. Because now in order to send the message i have to open outlook and
either say send/receive or press f5 as u said.

If somehow i could make it to ask for credentials when i press the send
button in outlook compose box (which is opened using word editor) then
everything is done in one shot

otherwise i again need to open outlook and then press F5 or send/receive
which will be an unneccessary extra step