View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matty[_3_] Matty[_3_] is offline
external usenet poster
 
Posts: 4
Default Sending spreadsheets through Lotus with a group mailbox


Any suggestions on how this can be accomplished...?



I figured out how to do this.

You would add a .Principal = "Your Group's Name" in the document
properties area of the code:

With objNotesDocument
.Subject = "Your Subject"
.Body = "Your Message"
.DisplayFrom = "Your Group's Name"
.Principal = "Your Group's Name"
.sendto = "Your Mailing List"
.SaveMessageOnSend = True ' save in Sent folder
.send (False)
End With