User Profile

Collapse

Profile Sidebar

Collapse
spl1490
spl1490
Last Activity: Aug 12 '10, 04:00 PM
Joined: Jul 27 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Sending attachments using vba and msoutl9.olb

    Hello,

    First off, I would like to say that I'm sorry for having to ask a programming site where to find a download for the outlook reference (msoutl9.olb) that is supposed to be in my C: drive. but I just joined and this community is pretty helpful so I thought I would ask.

    My problem come about when I try and use
    Code:
    Dim olApp As New Outlook.Application
    Dim olMail As Outlook.MailItem
    It tells me that...
    See more | Go to post

  • spl1490
    replied to Exporting multiple queries at once
    Oh my goodness. Thank you ever so much for that tip. I looked up how to code for arrays real quick, adjusted for my code, ran it and it works. code green, I couldn't have done it without you.
    See more | Go to post

    Leave a comment:


  • spl1490
    replied to Exporting multiple queries at once
    Arrays

    Thanks for the reply.

    I tried using arrays but I am pretty new to using VB and whatever I typed in kept giving me errors. Do you know of any examples that I could follow?
    See more | Go to post

    Leave a comment:


  • spl1490
    started a topic Exporting multiple queries at once

    Exporting multiple queries at once

    Hello,

    I have a list of people that I am looking to export a report to excel about for each of them separately. I have already done this for a set number of people, but I had to create a lot of queries and I need a way to alter my code so that if I add more people, the code will still be the same.

    I have a query that contains all the information I am trying to export and the specific report I want to export can be found...
    See more | Go to post
No activity results to display
Show More
Working...