Hi Bob, jumping in here too: Do you know how to make a msgbox popup
automatically upon opening the file?

"Bob Phillips" wrote:

Of course

Msgbox Range("A1").Value & "', your email has been sent", vbInformation

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ynissel" wrote in message
...
Bob,
Great - thanks, worked like a charm !
Can I spiff it up - like input the users name from a specific cell (a1)
into
the statement ?
Yosef

"Bob Phillips" wrote:

msgbox "Your email has been sent", vbInformation

It5 also shows one of those information buttons.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ynissel" wrote in message
...
How do I get my macro to pop up a message box that says "your email
has
been
sent" and just an OK button to continue ?
Thanks