Jim Doc said:
Tony Thanks so much! I reviewed your web site as you suggested and was able
to get eberything working in just a matter of hours!! Well, almost...I
can't find any properties for forcing Outlook to use the defined stationary
or signatures...If those could work, my solution would be totally automated.
The signatures have photos of the sales person in them. They can insert the
logo at the top and their signature at the bottom, but its just so ...
unelegant (if that's even a word!!)
Well, that is possible that would work. If you set a reference to
Outlook you should be able to browse the object model and possibly see
those stationery and signature options. Well, now that I take a look
I don't see any such.
Hmm, would CreateItemFromTemplate work?
You could try asking in the Outlook VBA newsgroup.
Note that you'll want to use Late Binding once the app is debugged to
handle workstations that don't have Outlook installed or a different
version of Outlook. Even if this doesn't happen now it will happen
when your IT staff starts to upgrade some of the workstations to a new
version of Outlook.
"Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm
Thanks again you were a huge help!!
You're quite welcome. Comments like yours make the effort worth
while.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm