Hi,
In a worksheet, I had a button and a macro to: copy and paste this worksheet into a new file, open Outlook (or whatever), join the new file as an attached file, fill the email address and subject. It works with Excel 97 and Outlook 97, but not with Outlook and Excel 2000. Can you help me please? Here is my code:
Sub Send_sample()
ActiveSheet.Select
ActiveSheet.Copy
Application.Dialogs(xlDialogSendMail).Show _
arg1:="email@email.com", _
arg2:="Subject of the form"
End Sub
Thanks!!
Jagzed
In a worksheet, I had a button and a macro to: copy and paste this worksheet into a new file, open Outlook (or whatever), join the new file as an attached file, fill the email address and subject. It works with Excel 97 and Outlook 97, but not with Outlook and Excel 2000. Can you help me please? Here is my code:
Sub Send_sample()
ActiveSheet.Select
ActiveSheet.Copy
Application.Dialogs(xlDialogSendMail).Show _
arg1:="email@email.com", _
arg2:="Subject of the form"
End Sub
Thanks!!
Jagzed