Sending e-mail

[verluc]

I have sheetA in workbookA that must be my body of an e-mail.
I have an e-mail database in sheetB of workbookB.
How can I COPY AND PASTE sheetA from workbookA in sheetB from workbookB
Many thanks for help.

[gareth]

Does it have to be cut and paste or do you want to email the single sheet.Well anyway,I have a code that sends the current sheet away.Please manipulate it if you want to.
Hop i'Ve been of assistance if any my friend.

[gareth]

As promised here is the code

Sub EMAIL()


Mailee = InputBox("Please Enter Name to Send sheet to.........")
subj = InputBox("Please enter eMail Subject..............")
Application.Dialogs(xlDialogSendMail).Show arg1:="", arg2:="As Requested"
Recipients = Mailee.Subject = subj.Close
End Sub

Enjoy it.