Sorry about that. I didn't realize that downloading the attachment in the post required registration. I plead laziness.
That was the sample I used for my own work and I had the link close at hand, so I didn't bother to search Tek-Tips itself.
Thanks for taking up my slack strongm! :)
-EM
Don't use msmapi! :) Since you're running on Windows 2003 server you have the CDOSYS object available to you. Try using that to send your mails directly to your SMTP server.
Check out this forum's post:
http://www.xtremevbtalk.com/showpost.php?p=1112396&postcount=5
Cheers,
-Elio
Just to throw some light on why VBA doesn't recognize the Excel constants.
mintjulep, you're probably using late binding (i.e. set myxlbook = create.object("excel.application")), right?
When you use this type of binding, VB doesn't have access to the Excel built-in constants.
Also, DEFINITELY...
I apologize right now for what follows.....
Did you hear they're performing science experiments on lawyers now?
They realized that there are just some things that mice will refuse to do!
Please don't hit me!! :)
Hi,
I had the same problem, albeit with Windows 2000. There may be other reasons, but in my case my hard drive was about to bite the bullet. Have you previously been hearing strange beeps and whirs while working with your computer? I did and thought nothing of it until the OS stopped letting me...
Hello.
I'm thinking of going into business for myself and I want to bill my company's software development services based on the man(or woman!)-hours used to complete each SDLC activity (Design, Programming, Unit Testing, etc..) within a project's individual tasks.
Does anyone know of...
Hello all,
I have a set of data that are created with a loop of the SelBookmarks in a TDBGrid. There are 5 lines in the original grid of which 3 were selected, however 4 lines were inserted (the last selected line was duplicated).
The code is something like this:
While...
Hello all.
A buddy of mine has a program to run for a university course and this DLL (MSFMNS.DLL) is required. The prof is a doofus that has not a clue where this file comes from. He has only stated that his program will not run on Windows XP and has not provided the DLL to his students.
Does...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.