Search results for query: *

I have 3 employees and all of them have the same external email set up (IMAP) in Outlook 2007. They've been using this set up for years with no issue, but I've suddenly run into problems with just one of them. When she sends an email from the IMAP email address, it ends up going out through her...

I'm still having this issue - wondering if anyone has any ideas for me. Thanks.

I have 3 employees and all of them have the same external email set up (IMAP) in Outlook 2007. They've been using this set up for years with no issue, but I've suddenly run into problems with just one of them. When she sends an email from the IMAP email address, it ends up going out through her...

Here is the code from the macro: Sub SpecialOrder() 'Working in 97-2010 Dim wb As Workbook Dim I As Long Set wb = ActiveWorkbook ActiveSheet.Buttons("Button 1019").Visible = False ActiveSheet.Buttons("Button 1018").Visible = False If Val(Application.Version) >= 12...

Thank you for the quick response. It is working (transfering data correctly and sending the email), but I keep getting: Run-time error '440': Automation error When I DeBug, it takes me to this line of code: oXLS.Run "SpecialOrder" Any idea what is causing this?

I have a command button in Access 2007 which transfers data from a form to an Excel workbook. Once the data is transfered, I would like to run a macro in Excel which emails a copy of the workbook to a specified individual. The transfer from Access to Excel works properly, and the macro in Excel...

The program that is generating the .txt file exports it in a way that will not allow it to properly import into Access. I need to modify the data in Excel prior to importing it into Access.

Sorry about that, should have included that the first time. Here is the Access code: Function mcr_importphonestats() On Error GoTo mcr_importphonestats_Err Call Shell("excel.exe ""C:\Documents and Settings\jewartj\My Documents\Stats\Daily CSR Production\Daily Stats.xls""", 1)...

I am a novice with Access, so please bear with me. Here are the basics of what I am trying to do, and the problem I am encountering: 1. I have a .txt file named Dailystats.txt 2. I have an Excel workbook named Dailystats.xls with an Auto_open macro that imports the data from Dailystats.txt...