Solved

Change "From:" Field Depending On Subject

Posted on 2008-10-22
2
597 Views
Last Modified: 2011-09-20
I have an MS Access database that features an AutoExec module which automatically sends an email if the query returns any results.  The database is scheduled to open on the server at 6AM every day.  The auto-email feature works perfectly.  The problem is that our accounting program also has auto-email features and uses the same server.  The Outlook account on the server is setup with "AccPac" as the profile name, so all emails sent from that account have "AccPac" in the From field.  I would like any emails sent from the MS Access database to have "BWW Bid Manager" in the From field.  Any solutions are appreciated.
0
Comment
Question by:bayouexpert
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
jmoss111 earned 500 total points
ID: 22782240
Hello bayouexpert,

Using CDO wouild remove the requirement for a profile.

Regards,

jmoss111
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read this checklist to learn more about the 15 things you should never include in an email signature.
Changing a few Outlook Options can help keep you organized!
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question