Chosing my OutApp outbox from Excel

[corquando]

Greetings.

Having learned that MSOffice 2003 really couldn't do this without a lot of hoops and hurdles, it was gratifying to learn that 2007 is able to have "choose your outbox" called from code. I think . . .

In any event, I have tried to see how this is done and cannot find it. I am truly fearful that it is not as easy as this:

With MyBook
.SaveAs ("P:\Huge\Large\Medium\Small\MyFile " + Format(Now, "dd-mmm-yy") + ".xls")
On Error Resume Next
With OutMail
[COLOR=red].From = "Me@MyChosenCompanyAccount"[/COLOR]
.To = "You@YourMailbox"
.CC = "He@HisMailbox"
.BCC = "She@HerMailbox"
.Subject = "Confirmation of transaction " & CStr(TrxNum) & " " & Format(CDate(Now), "d MMM yyyy")
.Body = "Thank you for your business." 
.Attachments.Add ("P:\Huge\Large\Medium\Small\MyFile " + Format(Now, "dd-mmm-yy") + ".xls")
.Send
End With
On Error GoTo 0
.Close SaveChanges:=False
End With
 
[\code]
 
That would be too easy.
 
What I wish to avoid is an "On Behalf Of" identifier. I do not wish my name to be attached to sends, as the documents are personal to the recipients and anything other than a corporate identity as a sender opens many unwanted doors.
 
Any takers?
 
Thanks in advance!

 

[VoG]

This should help http://www.rondebruin.nl/mail/account.htm

 

[corquando]

Thanks!

I'll do a little surgery and see what happens.

 

[corquando]

Excellent! It flew immediately and the big problem is knocked out.

So far so good . . . but now things get a little hairy(er), perhaps.

Is it possible to send from a particular mailbox within a chosen account?

If I have "Company Exchange Server : This is account number 1"

and

"Private Exchange Server : This is account number 2"

And I wish to name a particular mailbox from within either account while still avoiding the "on behalf of" identifier, is it possible?

I perused Mr. de Bruin's Mail page and didn't see anything regarding this particular situation. Maybe I'm being a little too OCD . . .

Again, many, many thanks in advance.