Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. boggsie

    With MailOutlook. ... mail shows up in sent items without sending

    Oh my < embarassed >. When I was workign on this (via SMTP) earlier in the week, I setup an In Box Rule to immediately post these message that were delivered to my In Box, to a separate folder. I only figured this out because I sent to another address (external to the Exchange Server in...
  2. boggsie

    With MailOutlook. ... mail shows up in sent items without sending

    So I went out and setup Wayne Phillips' Access/VBA to Outlook tweak and confirmed that it would send plain HTML messages. I then updated his test function to work with variables pointing to a recordset in the Access database. Again, the message appears in Sent Items but does not post to my In...
  3. boggsie

    With MailOutlook. ... mail shows up in sent items without sending

    I appreciate the quick response and your sage guidance. Unfortunately, the message still posts to my Sent Items without actually getting sent. I think you've more or less concerned that some local security policy must be interfering with the process on messages that are initiated in this...
  4. boggsie

    With MailOutlook. ... mail shows up in sent items without sending

    Ok, so a few of you most helpful members got me up and running with SMTP and a few days later, my port has been shut down by my provider. <sad face> So, I want to move this to actually creating the messages natively in Outlook and then clicking send. Problem is, the message does display, but...
  5. boggsie

    access vba smtp and undesired multiple attachments

    Giddy excited laughter ensues !!! THANK YOU!! Best regards, -boggsie
  6. boggsie

    access vba smtp and undesired multiple attachments

    Ok, thank you sir ... and, of course, a follow up. Now that you've shown me the way to get all of the items for a single message directly from the database, I need to get somewhat crafty with one of the elements, which happens to be a dynamically produced file. The file syntax is fixed, it...
  7. boggsie

    access vba smtp and undesired multiple attachments

    Ok, so what is your PayPal address? Magnificent ... Thank you SO VERY MUCH!! Best regards, -boggsie
  8. boggsie

    access vba smtp and undesired multiple attachments

    Hello folks!! I have a very odd issue. I am using the code to successfully send smtp out of Access 2007. I establish a connection with the local Access table to pull in the attributes of the message. One of the attributes is a path and file name to an attachement. Everything sends fine; no...
  9. boggsie

    MS Access 2007 - VBA Module - wait for condition, loop, continue

    Thank you for your response, Andy. The end to end runs as follows. I don't have much ability to re-architect the process. I submit three separate query requests to the "job". The job responds with a total of ten files. These ten files include data to be crunched and formatted. My original...
  10. boggsie

    MS Access 2007 - VBA Module - wait for condition, loop, continue

    This is where I ended up: I concluded that waiting for specific files was not necessary. I only need to ensure that I have accounted for the total number of files required to start the next process. I call CheckNumberFiles from a separate process to ensure that I have the number of files I...
  11. boggsie

    MS Access 2007 - VBA Module - wait for condition, loop, continue

    Another thought on this ... I know I need three files. Those will be the only files in the folder. dir folder if files <3 count to 30 loop else end I know I have three files and I can proceed or I wait 30 seconds and loop back.
  12. boggsie

    MS Access 2007 - VBA Module - wait for condition, loop, continue

    I am so very new to this I am almost embarassed to post. In this scenario: Data files incoming from different sources. Multiple files are required to proceed. Files are being dropped in a particular folder. So, I want to: Dim sFileA = c:\File_1.txt Dim sFileB = c:\File_2.txt Dim sFileC =...

Part and Inventory Search

Back
Top