Solved

Change "From:" Field Depending On Subject

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Are you using email marketing software? If not, you're missing out on effortless marketing and the reaching of desired conversion rates through email marketing software.
If you don't know how to downgrade, my instructions below should be helpful.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

22 Experts available now in Live!

Get 1:1 Help Now