You should be able to find something to help you here

'Example Code for sending mail from Excel'
(http://www.rondebruin.nl/sendmail.htm)


Thanks Barb,

I've already examined that link, but it's too complex for me.
Since I've to send/receive only one message during every Import/Export
task, I've temporarely solved my issue disabling (sending the mail) the
..send statement and enabling instead the .display, that don't trigger
the security alert. In this manner the user gets the new message Outlook
window with attachment already attached, the default recipients and
message subject already specified. He must only specify (if he likes)
other recipients and the body message and press the send button.

For the receiving task I've got the freeware program Express ClickYes
that "press" automatically the Yes button when Outlook asks if you like
to enable the application access to the inbox folder.

This could be a simple method to solve this issue to manage only one
message per time.

Regards,


--
eggpap

Emiliano
Excel 2003 on Vista HP System - can use VBA
------------------------------------------------------------------------
eggpap's Profile: http://www.thecodecage.com/forumz/member.php?userid=90
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90790