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?

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" <(E-Mail Removed)> wrote in message news:37C70CB8-BFAF-4CD5-8647-(E-Mail Removed)...
>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?

Sorry, I can't seem to view the original message.

You can do this in CDO, see here: http://www.outlookcode.com/d/code/selectnames.htm

Also there is a method in Outlook 2007, if you have it:
http://msdn2.microsoft.com/en-us/library/bb208172.aspx

HTH,
JP

On Jan 29, 12:08*pm, "Ron de Bruin" <rondebr...@kabelfoon.nl> 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 Bruinhttp://www.rondebruin.nl/tips.htm
>
>
>
> "Phil Martin" <PhilMar...@discussions.microsoft.com> wrote in messagenews:37C70CB8-BFAF-4CD5-8647-(E-Mail Removed)...
> >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 theuser
> > select the email address from that. Is that possible?- Hide quoted text -
>
> - Show quoted text -

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" <(E-Mail Removed)> wrote in message news:37C70CB8-BFAF-4CD5-8647-(E-Mail Removed)...
> >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?
>

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" <(E-Mail Removed)> wrote in message news:747676FB-A1E7-4226-B898-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:37C70CB8-BFAF-4CD5-8647-(E-Mail Removed)...
>> >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?
>>

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" <(E-Mail Removed)> wrote in message news:747676FB-A1E7-4226-B898-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message news:37C70CB8-BFAF-4CD5-8647-(E-Mail Removed)...
> >> >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?
> >>
>