Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Email from Excel Function

Set oOMail = oOApp.CreateItem(olMailItem)
With oOMail
.Display
.Body = eBody
.To = eTo
.CC = ecc
.Attachments.Add eAttach, olByValue, 1
.Subject = eSubject

.Send
End With


How do I add my signature?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Email from Excel Function

Hi Crazyhorse

See
http://www.rondebruin.nl/mail/folder3/signature.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Crazyhorse" wrote in message ...
Set oOMail = oOApp.CreateItem(olMailItem)
With oOMail
.Display
.Body = eBody
.To = eTo
.CC = ecc
.Attachments.Add eAttach, olByValue, 1
.Subject = eSubject

.Send
End With


How do I add my signature?

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Email from Excel Function

http://www.rondebruin.nl/mail/folder3/signature.htm
--
HTH,

Barb Reinhardt



"Crazyhorse" wrote:

Set oOMail = oOApp.CreateItem(olMailItem)
With oOMail
.Display
.Body = eBody
.To = eTo
.CC = ecc
.Attachments.Add eAttach, olByValue, 1
.Subject = eSubject

.Send
End With


How do I add my signature?

Thanks

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Email from Excel Function

I figured it out.

SigString = "C:\Documents and Settings\" & Environ("username") & _
"\Application Data\Microsoft\Signatures\Sig.txt"

If Dir(SigString) < "" Then
Signature = GetBoiler(SigString)
Else
Signature = ""
End If


Set oOMail = oOApp.CreateItem(olMailItem)
With oOMail
'.Display
.To = eTo
.CC = ecc
.Subject = eSubject
.Body = vbNewLine & vbNewLine & eBody & vbNewLine &
Signature
.Attachments.Add eAttach, olByValue, 1
.Send
End With
Set oOMail = Nothing



Function GetBoiler(ByVal sFile As String) As String
Dim fso As Object
Dim ts As Object
Set fso = CreateObject("Scripting.FileSystemObject")
Set ts = fso.GetFile(sFile).OpenAsTextStream(1, -2)
GetBoiler = ts.readall
ts.Close
End Function
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA macro to send email attachment from default email client wifigoo Excel Programming 2 April 12th 08 03:54 PM
Excel Function for Checking Email Syntax atr000 Excel Programming 12 July 20th 06 03:25 PM
email from Excel using If function DMCunningham Excel Worksheet Functions 3 June 20th 06 06:03 PM
Email editor closes when forwarding Excel-embedded email Bambina Setting up and Configuration of Excel 0 March 16th 06 10:45 PM
Add mailto (email) as function to a button in excel yagzzy Excel Worksheet Functions 1 May 1st 05 04:24 PM


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"