Re: excel data to outlook

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Stopher" <chris.sommerville@xxxxxxxxxxx>
Date: 15 Oct 2006 00:26:40 -0700

You could also try:

ActiveWorkbook.HasRoutingSlip = True
With ActiveWorkbook.RoutingSlip
.Recipients = "[email address here]"
.Subject = "[Insert sbject here]"
.Message = "[Insert the text string here]"
.Delivery = xlAllAtOnce
.ReturnWhenDone = False
.TrackStatus = False
End With
ActiveWorkbook.Route

.

References:
- excel data to outlook
  - From: netvigator.com
- Re: excel data to outlook
  - From: Rusty
- Re: excel data to outlook
  - From: netvigator.com

Prev by Date: Re: excel data to outlook
Next by Date: Re: Why can't I call my self-declared function?
Previous by thread: Re: excel data to outlook
Next by thread: Re: excel data to outlook
Index(es):
- Date
- Thread

Relevant Pages

Re: Mail Routing
... > .Delivery = xlOneAfterAnother ... > .ReturnWhenDone = True ... > .TrackStatus = True ...
(microsoft.public.excel.programming)
Mail Routing
... .Delivery = xlOneAfterAnother ... .ReturnWhenDone = True ... .TrackStatus = True ...
(microsoft.public.excel.programming)