Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Programming > Email active form using vb

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Email active form using vb

Reply to Message Icon

Name: LIZ
Date: September 20, 2003 at 08:27:11 Pacific
OS: winme/office2000
CPU/Ram: 500mhz
Comment:

I am try to get the active sheet to email. I have two differnt codes
Application.Dialogs(xlDialogSendMail).Show

which displays the email but if I use the 2nd code it does not attach the active page.

Sub SendEmail2()
Recipient = "emailaddress"
Subj = "Purchase Order"
Msg = "name"
Msg = Msg & "%0A" & "Please find the attached order "
Msg = Msg & "%0A" & "Regards"

Msg = Msg & "%0A" & "name"
Msg = Msg & "%0A" & "company"
HLink = "mailto:" & Recipient & "?"
HLink = HLink & "subject=" & Subj & "&"
HLink = HLink & "body=" & Msg
ActiveWorkbook.FollowHyperlink (HLink)
Application.Wait (Now + TimeValue("0:00:02"))
SendKeys "%s", True
End Sub

can anyone help Please?



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links
Ads by Google


Results for: Email active form using vb
activation form? www.computing.net/answers/programming/activation-form/15987.html

Sending test emails using vb www.computing.net/answers/programming/sending-test-emails-using-vb/17591.html

Active directory and vbs www.computing.net/answers/programming/active-directory-and-vbs/9764.html