Help! - Sending mails from Excel

[pmegha]

Hi,

I have with me, a macro that helps me send mails out to multiple people whose email ID's are present in a column of the excel file, based on certain conditions.

While the macro is serving its purpose, I have a requirement where in I need the "sent from" email ID to be one of the public mailboxes in outlook (and not my default personal email ID).

I am seeking advice on how this can be set - would it be modifications in the excel code or Outlook settings?

Many thanks!

 

[CharlesChuckieCharles]

Hi,

I have with me, a macro that helps me send mails out to multiple people whose email ID's are present in a column of the excel file, based on certain conditions.

While the macro is serving its purpose, I have a requirement where in I need the "sent from" email ID to be one of the public mailboxes in outlook (and not my default personal email ID).

I am seeking advice on how this can be set - would it be modifications in the excel code or Outlook settings?

Many thanks!

Post the code (and look up the vba help on the mail function)

 

[daverunt]

See if this is relevant.

http://www.mrexcel.com/forum/showthread.php?t=526806