msoutlook.org Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Automation to send email from Group box

 
Post new topic   Reply to topic    msoutlook.org Forum Index -> Outlook Teamfolders
Author Message
David



Joined: 12 Aug 2007
Posts: 15

PostPosted: Mon Aug 27, 2007 11:40 am    Post subject: Automation to send email from Group box Reply with quote

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

Archived from group: microsoft>public>outlook>teamfolders
Back to top
View user's profile Send private message
Ken Slovak - [MVP - Outlo



Joined: 12 Aug 2007
Posts: 405

PostPosted: Mon Aug 27, 2007 3:22 pm    Post subject: Re: Automation to send email from Group box Reply with quote

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" wrote in message @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
Back to top
View user's profile Send private message
David



Joined: 12 Aug 2007
Posts: 15

PostPosted: Mon Aug 27, 2007 2:10 pm    Post subject: Re: Automation to send email from Group box Reply with quote

Thank you for the quick response Ken.


Let's assume I have been setup properly and have send as permissions.


How can I modify the From field?



"Ken Slovak - [MVP - Outlook]" wrote:

> 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" wrote in message
> @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
>
>
Back to top
View user's profile Send private message
Ken Slovak - [MVP - Outlo



Joined: 12 Aug 2007
Posts: 405

PostPosted: Tue Aug 28, 2007 1:14 pm    Post subject: Re: Automation to send email from Group box Reply with quote

Display From and set it to what you want. I have a mailbox named "Sales"
that I have SendAs permissions for, I just enter "Sales" in From and send
the email.

--
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" wrote in message @microsoft.com...
> Thank you for the quick response Ken.
>
>
> Let's assume I have been setup properly and have send as permissions.
>
>
> How can I modify the From field?

Back to top
View user's profile Send private message
Display posts from previous:   
Related Topics:
Outlook locks up replying to YAHOO email addresses When recieving email from anyone at Yahoo.com I can view the email, but when I click on REPLY, my outlook freezes. I use Trend Micro Internet security 2007. I thought it might be an update, but I installed Trend Micro 2008 on another machine and it also f

Outloook automation via c++ Hello, I´m having problems using the automation for Outlook. For example I want to add an new Mail in the in-box (in german Posteingang). When I create a new mailitem and I save it, the new EMail will be saved in the folder: "drafts" (in german: Entwürfe

Mail Merge Help - Fax Automation Hi All, Scenario: 1.) Have Word mail merge document and Excel spreadsheet. 2.) The mail merge document is a standard letter with about 5 or 6 merge fields from the Excel spreadsheet. See sample below. "Dear «First_Name» «Last_Name», «Degree»: «Fax» Thank

setting up exchange/outlook to allow automation I'm in looking into the options to get an access program to successfully send emails (and avoid the anti-virus dialog box). The instructions state "outlook 2002" - will these controls work if the client has outlook 2000 (sp3

Automation using Outlook Template File (*.oft) Hi! I have this problem to solve: someone gave me an Outlook template file, and I need with automation (by a Visual Basic 6.0 program) to add 2 things taken from a Database in the template, before sending it. For example I need to change
Post new topic   Reply to topic    msoutlook.org Forum Index -> Outlook Teamfolders All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group