Send SMTP mail (with attachments), without using Outlook
| Author |
Message |
|
Jon Le
#1 / 11
|
 Send SMTP mail (with attachments), without using Outlook Our company has successfully used Access to send reports to clients (usually in SnapShot Viewer format) by adding a reference to Outlook and using this to create mail items. However, for various reasons, we now wish to migrate one of our apps to a Citrix enviroment. For those not familiar with Citrix, this effectively means that everyone is running the app from the same machine, the Citrix server, rather than from their local machine. The local machine is just acting as a dumb terminal. The problem comes with the email side of things - basically, the way we currently do it, everyone who uses this app would have to have an email profile set up on the Citrix server, and every time we had a new user (even if it was just a temp for a couple of days, who we would not normally give email access to), we would have to set up a new profile on the server. What I am after is a method of sending emails that by-passes Outlook and
talks directly to the SMTP server. Any ideas?
Thanks,
Jon Ley.
|
| Mon, 16 Aug 2004 17:04:02 GMT |
|
 |
|
Michael Gross
#2 / 11
|
Send SMTP mail (with attachments), without using Outlook Try it with CDO (Collaboration Data Objects), from there you can access the smtp protocoll directly... just type "cdo" in the search field Quote: >-----Original Message-----
>Our company has successfully used Access to send reports
to clients (usually
>in SnapShot Viewer format) by adding a reference to
Outlook and using this Quote: >to create mail items. However, for various reasons, we now
wish to migrate
>one of our apps to a Citrix enviroment. For those not
familiar with Citrix, Quote: >this effectively means that everyone is running the app
from the same
>machine, the Citrix server, rather than from their local
machine. The local
>machine is just acting as a dumb terminal. The problem
comes with the email Quote: >side of things - basically, the way we currently do it,
everyone who uses
>this app would have to have an email profile set up on the
Citrix server,
>and every time we had a new user (even if it was just a
temp for a couple of Quote: >days, who we would not normally give email access to), we would have to set >up a new profile on the server. >What I am after is a method of sending emails that
by-passes Outlook and Quote: >talks directly to the SMTP server. Any ideas? >Thanks,
>Jon Ley.
>.
|
| Mon, 16 Aug 2004 20:06:35 GMT |
|
|
|
Roberto Spie
#3 / 11
|
Send SMTP mail (with attachments), without using Outlook Jon, check out about Simple MAPI, you can download a demo from Sample Code
section,
on www.trigeminal.com
It may do a trick.
Roberto
Quote: > Our company has successfully used Access to send reports to clients (usually > in SnapShot Viewer format) by adding a reference to Outlook and using this > to create mail items. However, for various reasons, we now wish to migrate > one of our apps to a Citrix enviroment. For those not familiar with Citrix, > this effectively means that everyone is running the app from the same > machine, the Citrix server, rather than from their local machine. The local > machine is just acting as a dumb terminal. The problem comes with the email > side of things - basically, the way we currently do it, everyone who uses > this app would have to have an email profile set up on the Citrix server, > and every time we had a new user (even if it was just a temp for a couple of > days, who we would not normally give email access to), we would have to set > up a new profile on the server. > What I am after is a method of sending emails that by-passes Outlook and
> talks directly to the SMTP server. Any ideas?
> Thanks,
> Jon Ley.
|
| Mon, 16 Aug 2004 21:13:53 GMT |
|
|
|
Jon Le
#4 / 11
|
Send SMTP mail (with attachments), without using Outlook Roberto, Not quite what I'm after. Yes, it does bypass Outlook, but from my brief
testing, it does still seem to require you to have a mail profile
configured. Why do I assume this? For one, the test message still ends up in
my Outlook 'Sent Items' folder. Secondly, there does not seem to be anywhere
to specify a logon to an SMTP mail server (which I would need if I didn't
have a mail profile configured).
Does anyone have any other ideas?
Jon.
Quote: > Jon, > check out about Simple MAPI, you can download a demo from Sample Code
> section,
> on www.trigeminal.com
> It may do a trick.
> Roberto
> > Our company has successfully used Access to send reports to clients
> (usually
> > in SnapShot Viewer format) by adding a reference to Outlook and using
this
> > to create mail items. However, for various reasons, we now wish to
migrate
> > one of our apps to a Citrix enviroment. For those not familiar with
> Citrix,
> > this effectively means that everyone is running the app from the same
> > machine, the Citrix server, rather than from their local machine. The
> local
> > machine is just acting as a dumb terminal. The problem comes with the
> email
> > side of things - basically, the way we currently do it, everyone who
uses
> > this app would have to have an email profile set up on the Citrix
server,
> > and every time we had a new user (even if it was just a temp for a
couple
> of
> > days, who we would not normally give email access to), we would have to
> set
> > up a new profile on the server.
> > What I am after is a method of sending emails that by-passes Outlook and
> > talks directly to the SMTP server. Any ideas?
> > Thanks,
> > Jon Ley.
|
| Tue, 17 Aug 2004 02:05:45 GMT |
|
|
|
Mike Prest
#5 / 11
|
Send SMTP mail (with attachments), without using Outlook For all things email, check out Tony Toews site: http://www.granite.ab.ca/accsmstr.htm
Also, Chuck Grimsby has previously posted code (as have others) to
directly access SMTP:
http://groups.google.com/groups?selm=3b79096d.619373712%40news.CIS.DF...
mike
Quote: >Roberto, >Not quite what I'm after. Yes, it does bypass Outlook, but from my brief
>testing, it does still seem to require you to have a mail profile
>configured. Why do I assume this? For one, the test message still ends up in
>my Outlook 'Sent Items' folder. Secondly, there does not seem to be anywhere
>to specify a logon to an SMTP mail server (which I would need if I didn't
>have a mail profile configured).
>Does anyone have any other ideas?
>Jon.
>> Jon,
>> check out about Simple MAPI, you can download a demo from Sample Code
>> section,
>> on www.trigeminal.com
>> It may do a trick.
>> Roberto
>> > Our company has successfully used Access to send reports to clients
>> (usually
>> > in SnapShot Viewer format) by adding a reference to Outlook and using
>this
>> > to create mail items. However, for various reasons, we now wish to
>migrate
>> > one of our apps to a Citrix enviroment. For those not familiar with
>> Citrix,
>> > this effectively means that everyone is running the app from the same
>> > machine, the Citrix server, rather than from their local machine. The
>> local
>> > machine is just acting as a dumb terminal. The problem comes with the
>> email
>> > side of things - basically, the way we currently do it, everyone who
>uses
>> > this app would have to have an email profile set up on the Citrix
>server,
>> > and every time we had a new user (even if it was just a temp for a
>couple
>> of
>> > days, who we would not normally give email access to), we would have to
>> set
>> > up a new profile on the server.
>> > What I am after is a method of sending emails that by-passes Outlook and
>> > talks directly to the SMTP server. Any ideas?
>> > Thanks,
>> > Jon Ley.
|
| Tue, 17 Aug 2004 03:18:32 GMT |
|
|
|
Jon Le
#6 / 11
|
Send SMTP mail (with attachments), without using Outlook Mike, You're a life-saver! Chuck's posting looks to be exactly what I'm after. All
I need to do now is find some documentation for the WinSock control, and
learn the syntax for the various SMTP commands. I'm off now to go and search
the Internet for these, but in the meantime, if you have any pointers they
would be greatfully received. In particular, I need to know how to send
attachments (the posting in the link below gets as far as asking this
question, but doesn't have the response).
Thanks again for your help,
Jon.
Quote: > For all things email, check out Tony Toews site: > http://www.granite.ab.ca/accsmstr.htm
> Also, Chuck Grimsby has previously posted code (as have others) to
> directly access SMTP:
http://groups.google.com/groups?selm=3b79096d.619373712%40news.CIS.DF... tput=gplain Quote:
|
| Tue, 17 Aug 2004 18:03:42 GMT |
|
|
|
Andy Jeffre
#7 / 11
|
Send SMTP mail (with attachments), without using Outlook You seem to have found a solution, but just if you are still looking for alternatives, we use a Public Domain program called blat to send mails from NT. I'm not sure if it will send attachments, but you can find it at http://www.interlog.com/~tcharron/blat.html. Andy Jeffrey
Quote: > Our company has successfully used Access to send reports to clients (usually > in SnapShot Viewer format) by adding a reference to Outlook and using this > to create mail items. However, for various reasons, we now wish to migrate > one of our apps to a Citrix enviroment. For those not familiar with Citrix, > this effectively means that everyone is running the app from the same > machine, the Citrix server, rather than from their local machine. The local > machine is just acting as a dumb terminal. The problem comes with the email > side of things - basically, the way we currently do it, everyone who uses > this app would have to have an email profile set up on the Citrix server, > and every time we had a new user (even if it was just a temp for a couple of > days, who we would not normally give email access to), we would have to set > up a new profile on the server. > What I am after is a method of sending emails that by-passes Outlook and
> talks directly to the SMTP server. Any ideas?
> Thanks,
> Jon Ley.
|
| Tue, 17 Aug 2004 19:51:30 GMT |
|
|
|
Mike Prest
#8 / 11
|
Send SMTP mail (with attachments), without using Outlook Quote:
>Mike, >You're a life-saver! Chuck's posting looks to be exactly what I'm after. All
>I need to do now is find some documentation for the WinSock control, and
>learn the syntax for the various SMTP commands. I'm off now to go and search
>the Internet for these, but in the meantime, if you have any pointers they
>would be greatfully received. In particular, I need to know how to send
>attachments (the posting in the link below gets as far as asking this
>question, but doesn't have the response).
Actually, I didn't want to impose on Chuck because I presumed the answer was far from trivial. Essentially, since SMTP is text only, you will need to run the file you want to attach through a text encoding routine. I have frequently used text decoding routines to extract attachments (munpack.exe is a common one), but I've not used any encoders. If you find that thread on google (search this group for something
like "Private Sub WaitForIt" should get you there) you will find that
the thread was based on my discovering that Access can control a
third-party email application (Pegasus) through DDE. Chuck was
offering an alternative to requiring the user to install a third-party
app for automating email.
A real email client will handle things such as attachments,
distribution lists and the timing of connection to the internet
without fuss. Rolling one's own must take into account those things,
in addition to the simple commands for sending an email message
itself.
Maybe, as indicated elsewhere, blat can be viewed as the middle
ground?
mike
Quote: >Thanks again for your help,
>Jon.
>> For all things email, check out Tony Toews site:
>> http://www.granite.ab.ca/accsmstr.htm
>> Also, Chuck Grimsby has previously posted code (as have others) to
>> directly access SMTP:
>http://groups.google.com/groups?selm=3b79096d.619373712%40news.CIS.DF...
>tput=gplain
>> mike
|
| Wed, 18 Aug 2004 01:16:58 GMT |
|
|
|
Tony Toew
#9 / 11
|
Send SMTP mail (with attachments), without using Outlook Quote:
>You're a life-saver! Chuck's posting looks to be exactly what I'm after. All
>I need to do now is find some documentation for the WinSock control, and
>learn the syntax for the various SMTP commands. I'm off now to go and search
>the Internet for these, but in the meantime, if you have any pointers they
>would be greatfully received. In particular, I need to know how to send
>attachments (the posting in the link below gets as far as asking this
>question, but doesn't have the response).
Take a look at the Activex Controls though. The following are some links I found when doing some TCP/IP research. Nothing to do
with attachments though.
Google Web Directory - Computers Programming Internet Sockets
http://directory.google.com/Top/Computers/Programming/Internet/Sockets/
Windows Sockets Programming
http://www.snible.org/winsock/
Visual Basic Internet Programming
http://www.vbip.com/
Visual Basic Internet Programming - Tools&Technologies
http://www.vbip.com/tools.asp
Organising Communication with WinSocket - visual basic, vb, VBScript
http://www.planet-source-code.com/xq/ASP/txtCodeId.22320/lngWId.1/qx/...
15 Seconds Creating a TCP Component in Visual Basic
http://www.15seconds.com/issue/990408.htm
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
|
| Thu, 19 Aug 2004 05:40:34 GMT |
|
|
|
Michael Gross
#10 / 11
|
Send SMTP mail (with attachments), without using Outlook As far as i know using blat means deactivating the smtp service of IIS, which can cause various probs. If you're not running the Internet Information Server you can use this program without trouble. Greetings
Michael
Quote: >-----Original Message----- >You seem to have found a solution, but just if you are still looking for >alternatives, we use a Public Domain program called blat to send mails from >NT. I'm not sure if it will send attachments, but you can find it at >http://www.interlog.com/~tcharron/blat.html. >Andy Jeffrey
>> Our company has successfully used Access to send reports
to clients
>(usually
>> in SnapShot Viewer format) by adding a reference to
Outlook and using this Quote: >> to create mail items. However, for various reasons, we now wish to migrate >> one of our apps to a Citrix enviroment. For those not familiar with >Citrix, >> this effectively means that everyone is running the app from the same >> machine, the Citrix server, rather than from their local machine. The >local >> machine is just acting as a dumb terminal. The problem comes with the >email >> side of things - basically, the way we currently do it, everyone who uses >> this app would have to have an email profile set up on the Citrix server, >> and every time we had a new user (even if it was just a temp for a couple >of >> days, who we would not normally give email access to), we would have to >set >> up a new profile on the server. >> What I am after is a method of sending emails that
by-passes Outlook and Quote: >> talks directly to the SMTP server. Any ideas? >> Thanks,
>> Jon Ley.
>.
|
| Fri, 20 Aug 2004 22:41:55 GMT |
|
|
|
Jon Le
#11 / 11
|
Send SMTP mail (with attachments), without using Outlook Tony, Thanks for all these links. I haven't had a chance to look through them yet
('coz I've got more pressing jobs I need to get done first), but I promise I
will ...
Jon.
Quote:
> >You're a life-saver! Chuck's posting looks to be exactly what I'm after.
All
> >I need to do now is find some documentation for the WinSock control, and
> >learn the syntax for the various SMTP commands. I'm off now to go and
search
> >the Internet for these, but in the meantime, if you have any pointers
they
> >would be greatfully received. In particular, I need to know how to send
> >attachments (the posting in the link below gets as far as asking this
> >question, but doesn't have the response).
> Take a look at the Activex Controls though.
> The following are some links I found when doing some TCP/IP research.
Nothing to do
> with attachments though.
> Google Web Directory - Computers Programming Internet Sockets
> http://directory.google.com/Top/Computers/Programming/Internet/Sockets/
> Windows Sockets Programming
> http://www.snible.org/winsock/
> Visual Basic Internet Programming
> http://www.vbip.com/
> Visual Basic Internet Programming - Tools&Technologies
> http://www.vbip.com/tools.asp
> Organising Communication with WinSocket - visual basic, vb, vbscript
http://www.planet-source-code.com/xq/ASP/txtCodeId.22320/lngWId.1/qx/... pts/ShowCode.htm Quote: > 15 Seconds Creating a TCP Component in Visual Basic
> http://www.15seconds.com/issue/990408.htm
> 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
|
| Sun, 22 Aug 2004 21:33:55 GMT |
|
| |
|
