Sending spreadsheets through Lotus with a group mailbox

[Matty]

I have a macro setup to automatically send a copy of a spreadsheet via
Lotus Notes whenever the spreadsheet is updated.

However, Notes always uses my personal mailbox to send the email.
Ideally, the email would be sent from a group mailbox on a different
server.

I have specied the different mailbox in the vba code, but Lotus still
uses my personal mailbox as the default to send the emails.

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

Thanks,

- Matty

 

[Matty]

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