Search results

  1. S

    ODBC to MS SQL server tables from Access

    I created an Access 2000 database a few years ago and ressurectected it recently with Access 2007. The database connects via ODBC to SQL server tables. I recently added an access form with one combo box that uses one of the ODBC tables to fill in its vaules. The user selects a value from the...
  2. S

    Specify 'From' in VBA code for outlook mail message

    .SenderName worked Thank you both for the suggestions, .SenderName does work. I thought I was going to be forced to revert to using SendKeys! Once again your suggestions are greatly appreciated!!
  3. S

    Specify 'From' in VBA code for outlook mail message

    .sender didn't work Thanks for the suggestion, SforSoftware, but .sender isn't supported in "with mailoutlook" either. Any other ideas?
  4. S

    Specify 'From' in VBA code for outlook mail message

    I have an existing module that creates an outlook mail message. This works great except I can’t specify “from” in my code. I realize .from isn’t supported, What method should I use instead of “with mailoutlook”? Below is my existing code: Private Sub SendMailPro_Click() Set appoutlook =...
  5. S

    Display data from text file using VBA

    I'd like to display the contents of a text file located on a network drive with my VBA module. I have a VBA module in Access 2002 that creates an outlook HTML email message. Currently, I either have to hard code the recipients individually or hard code an outlook distribution list name. I'd...
  6. S

    Save outlook attachment to sub folder not working

    figured it out Had to put the \ charcter in the file name string: FileName = FolderPath & "\" & Atmt.FileName
  7. S

    Save outlook attachment to sub folder not working

    I've borowed a module from www.fontstuff.com The code saves email attachments from outlook folders to regular file system folders. Everything works great if the folder being saved to isn't a sub folder. For instance, if I just save to "d:" it works fine. But if I try to save to "d:temp", the...
  8. S

    Monthly Email

    Animated .gif It's an animated .gif file, each movement is a separate gif file or "layer". You display each layer for about .5 seconds and then move to the next layer. I use Adobe ImageReady but if you want a free program, there are a ton out there. If you do a search on download.com for...
  9. S

    Export Query Results to Email Message

    I use an Access database to collect data from a linked text file and other manual check boxes. This information is displayed on a form and sub form. I send this information out on a daily basis so have come up with an event proceedure that forms an outlook mail message. I've got the fields on...
Back
Top Bottom