Solved

Change "From:" Field Depending On Subject

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
This is my first article on Expert Exchange on the Manual Method of Exporting Office 365 Mailboxes to PST format by using the eDiscovery mechanism of Office. Hope you will enjoy the article.
The purpose of this video is to demonstrate how to set up a Mailchimp campaign. This will include styling and adding elements to a newsletter/email. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchim…
The purpose of this video is to demonstrate how to use PicMonkey software to customize images for a Mailchimp campaign. Picmonkey is free and simple online software which can be used by users who don’t have robust editing software such as Photoshop,…

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now