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

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