attach to email
 

Hi! I am trying to write a macro that would take a
worksheet and attach it to an email in outlook. I know
there is a button for this function, but the worksheet
must also have alterations done to it before attaching
and therefore I can't use the button. I need to know what
the code is to take you directly to a new mail message
and attach the worksheet to the email. Any help would be
great! Thanks,
Eric

attach to email
 

Application.Dialogs(xlDialogSendMail).Show

"Eric" wrote in message
...
Hi! I am trying to write a macro that would take a
worksheet and attach it to an email in outlook. I know
there is a button for this function, but the worksheet
must also have alterations done to it before attaching
and therefore I can't use the button. I need to know what
the code is to take you directly to a new mail message
and attach the worksheet to the email. Any help would be
great! Thanks,
Eric

attach to email
 

Eric,

check out this site
http://www.dicks-clicks.com/excel/olSending.htm

--
sb
"Eric" wrote in message
...
Hi! I am trying to write a macro that would take a
worksheet and attach it to an email in outlook. I know
there is a button for this function, but the worksheet
must also have alterations done to it before attaching
and therefore I can't use the button. I need to know what
the code is to take you directly to a new mail message
and attach the worksheet to the email. Any help would be
great! Thanks,
Eric