Solved

Change "From:" Field Depending On Subject

Posted on 2008-10-22
2
598 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

729 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