Search results

No error messages, nothing. The emails go through on an XP and Office 2003 machine, but not Windows 7 and Office 2007. Ghudson, what kind of code are you using? I have tried regular outlook coding but the warning message always comes up, that Outlook is trying to send an automated email...

In Access 2003, I could test the emails and either get an error message or the email went through. In Access 2007 and Outlook 2007, I get no error message and the email appears to have gone through. Here is the code: ------------------------------- Function SendEmailNotice(EmailTo As String...

Another question for you, what's the best method in 2007 to send emails? I've been using Redemption.dll but many emails don't get through...(another 2007 problem, lol)

OMG, Bob, you are amazing!!!!!! It surely worked like a charm!!! I adjusted some code to fit my variables. Some new commands I must learn, huh with 2007?

Cool...I'll try that in a second.....

So you're saying to do this?: strdb = "DatabaseOne.mde" Set AppAccess = GetObject(strDB, "Access.Application") AppAccess.UserControl = True AppAccess.Quit (which would mean the command .userControl sort of sets the focus back to the 1st database?)

From one Access 2007 database, I'm using automation to open another Access 2007 database. I want the first database to close after the 2nd one opens. I cannot use followhyperlink or Shell command to open the 2nd database because it is password protected. Because it's automation, I cannot drop...