Sending E-mail

[thatjayguy]

I am creating a userform and would like to include a "Mail to author" link. All I want it to do is open up a new message and allow the user to enter the e-mail "body" to explain any difficulties that they are having.

In "standard" VB there is a feature where you simply write
mailto:recipient. Is there nothing similar in Excel 97? I have looked at the sendmail procedure but it doesn't seem to allow for any "body" text to be entered by the user. Is this so or is there a way to specify the text.

Thanks,

 

[RobBroekhuis]

Two ways to go about it:

- If your e-mail platform is Outlook, you can use Outlook VBA to send an email with all necessary bells and whistles. Not real simple, but definitely manageable

- You could also ask for the body on a userform, then copy the userform text to a worksheet cell on a newly created workbook, and use sendmail to send this workbook. Not as flashy or convenient, but a quicker fix.

Rob

 

[Nikita6003]

Hi,

ever tried the routing option? Al long as you're using MAPI I think it'll work:

Dim l_wkbSend As WorkBook

Set l_wkbSend = Application.Workbooks("BOOK1.XLS").Open
l_wkbSend.HasRoutingSlip = True

With l_wkbSend.RoutingSlip
    .Delivery = xlOneAfterAnother
    .Recipients = Array("Tom", "Dick", "Harry")
    .Subject = "Here is an xl workbook"
    .Message = "Sending you the workbook. Comments please asap."
End With
l_wkbSend.Route

Set l_wkbSend = Nothing

HTH - can't check code - using LoNo meself ...

Cheers
Nikki

 

[thatjayguy]

The project I'm currently on uses Outlook, but as a company we use something else. Because I want to make this work once I'm back on our main system I was avoiding using the Outlook VBA.

Your idea for using a new workbook as a container for the body is an interesting approach and something that I'll definetly look into.

Thanks for your reply.

 

[thatjayguy]

Nikita6003,

This may be the solution I was looking for. Just being lazy....but do you happen to know if the .recipients will accept a full email address?

i.e. somebody@somecompany.som

Or does it require access to a "centralized" mail list?

Thanks,

 

[Nikita6003]

Well, as far as I can remember it'll work with internet email addresses such as name@wotsit.com

But the only way to be sure is to give it a go ...

Cheers - & good luck ;-)
Nikki

 

[Nikita6003]

I tested it on my boyfriend's pc - he's got outlook xpress - and it worked there - got a msg sent to my hotmail account!

Chers
Nikki

 

[Nikita6003]

Only thing it does it attaches this bit of text to your message:

The attached document has a routing slip. "When you are done reviewing this document, choose Next Routing Recipient from the Microsoft Excel Send To menu on the File menu to return the document to its sender."

Dunno if that can be suppressed ..

Cheers again
Nikki