Dear Experts,
I saw loads of threads on emailing a ws but I still cannot solve my simple?? case.
I have a macro below to automatically attach a ws -- and a recipient -- to a new email window with the code below.
It brings up the email window ok and it DOES attach my ws but it doesnot attach the recipient???
Whats the flaw here. Please I also want the code to work independently form the user email.
Pls help.
Nee
=====================
Sub SendIt ()
Application.Dialogs(xlDialogSendMail).Show _
arg1:="abc@abc.com", _
End Sub
======================