Automation to send email from Group box

Hello all,
I'm not getting much support from IT, so my details may be a bit off. I
have had them setup a group email on our exchange server. My Outlook has my
inbox and the group inbox. In access, I have mapped to the group inbox, the
location is on my c drive...\ local\Temp\Inbox

I can modify the To, CC, BCC, Subject and Body of the email. How can I
modify the FROM field so the email shows from the Group and not my personal
email?

Sample code I use for Outlook Automation in Access 2003 VBA.


Set objOutlook = CreateObject("Outlook.Application")

' Create the message.
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)


With objOutlookMsg
' Add the To recipient(s) to the message.


Set objOutlookRecip = .Recipients.Add("David@company.com")
objOutlookRecip.Type = olTo



Any assistance you can provide would be greatly appreciated.

David

Is this an Exchange mailbox or a PST file? If it's an Exchange mailbox and
you have send as permissions on it just use the mailbox alias in the From
field. Your admins have to set up the send as permissions. If you don't have
that the best you can do is using SendOnBehalfOf and that will show up as
from you with the sent on behalf of notation in the message.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"David" <David RemoveThis @discussions.microsoft.com> wrote in message
news:E4C9C227-6CCC-4BB7-BA9E-9D6BFB28B2EF@microsoft.com...
> Hello all,
> I'm not getting much support from IT, so my details may be a bit off. I
> have had them setup a group email on our exchange server. My Outlook has
> my
> inbox and the group inbox. In access, I have mapped to the group inbox,
> the
> location is on my c drive...\ local\Temp\Inbox
>
> I can modify the To, CC, BCC, Subject and Body of the email. How can I
> modify the FROM field so the email shows from the Group and not my
> personal
> email?
>
> Sample code I use for Outlook Automation in Access 2003 VBA.
>
>
> Set objOutlook = CreateObject("Outlook.Application")
>
> ' Create the message.
> Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
>
>
> With objOutlookMsg
> ' Add the To recipient(s) to the message.
>
>
> Set objOutlookRecip = .Recipients.Add("David@company.com")
> objOutlookRecip.Type = olTo
>
>
>
> Any assistance you can provide would be greatly appreciated.
>
> David