Copy to Netscape 6.2 E-mail

skipper

New Member
Joined
Apr 3, 2002
Messages
2
HELP! I am trying to copy specified cells from an Office 97 spreadsheet with SR2 installed into a Netscape 6.2 e-mail. It does not copy! I have to copy it into a word document then from the word document into the e-mail. I really need help on this as I am spending WAY too much time trying to figure this out and search for an answer
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Try the following:

Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long
Sub SendMail()

Dim URL As String, Email As String
Email = "youremail@email.com"
URL = "mailto:" & Email & "?subject=" & "Insert Subject" & "&body=" & "Insert Buffers"
ShellExecute 0&, vbNullString, URL, vbNullString, vbNullString, vbNormalFocus
Application.Wait (Now + TimeValue("0:00:01"))
Application.SendKeys "%s"

End Sub

You can insert anything you want into the subject and body of the message (variables, cell values).
 
Upvote 0
Hi Al,
I am just trying to copy cells into the body of text and it is coming up blank! Not sure if it is a netscape, XP or excel problem. I used to be able to do it all the time and now I have to copy into a word doc then into the e-mail.
 
Upvote 0
Oh, I misunderstood your problem. You can use my script to do it automatically :)
I don't use netscape or XP, so I'm not a lot of help.
This message was edited by Al Chara on 2002-04-04 08:42
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top