Hi Ron,

Works perfectly, thanks very much

"Ron de Bruin" wrote:

Hi Phil

Then use

.SendMail "", _
"This is the Subject line"

If the To is "" empty it will display the mail and the user can use the address book


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Phil Martin" wrote in message ...
Hi Ron,

The sendmail is in the code. At the moment the user does not see the mail.
It acts like it is a background process

"Ron de Bruin" wrote:

Hi Phil

Display the mail and let the user choose

Do you use SendMail in the code or the Outlook object model


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Phil Martin" wrote in message ...
I have a spreadsheet that mails itself to an end user upon completion. The
recipient is specified by the user. At the moment this is by using inputbox.
What I would like to do is bring up the Outlook address book and let the user
select the email address from that. Is that possible?