PDA

View Full Version : Sending email with lotus notes using data from excel



gurfi1
02-13-2010, 02:04 AM
Hello,
I'm using this simple code to generate email in lotus notes from excel:

Private Sub CommandButton1_Click()
Application.CutCopyMode = False
Range("A1:G44").Select
Selection.Copy
ActiveWorkbook.FollowHyperlink "mailto:Cohen@intel.com (Cohen@intel.com), Eyal@asml.com, ng@intel.com, ?subject= LASERS passdown"
End Sub

I can copy the data i want to use as message body (A1:G44)
But need to use manual CTRL+V to paste it.
Is there any solution to it?

Thanks.
Alex