Re: sending mail from vba with unknown client software

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter (peterguy)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 13:59:10 -0800

5 minutes of googling brought up these links (watch the wrapping):

http://www.febooti.com/products/command-line-email/online-help/send-email-ms-access.html
http://www.theofficeexperts.com/VBASamples/Access01.htm
http://forums.devarticles.com/archive/t-9457

I'm sure there's more out there; you're most likely not the first to do this.

If you're really trying to target the broadest possible swath of end-users, you might consider turning your app into a web-based app.

-Peter

"Dave" <noone@nowhere.com> wrote in message news:uXlLiRkyEHA.2084@TK2MSFTNGP10.phx.gbl...
> ok. no answer to the query about the 255 character limit on control's
> hyperlinkaddress property... it does seem to be that way, no way i have
> found around it...
>
> so what are other possibilities for generating email from vba in access?? i
> have no control over mail clients nor mail servers used. i can not even
> expect the machines to have ms office. so how would you generate emails in
> a very general fashion from vba?
>
> some ideas i have had include putting in the ie control and feeding it the
> mailto: link, does that avoid the 255 character limit??
>
> where i have done this before and had control of an smtp server i have put
> in my own smtp client, but this case i can't count on that type of access...
> should i reconsider this maybe? these will all be home users with unknown
> isp's and skill levels, should they be expected to be able to configure the
> smtp server info? is this even possible with isp security restrictions??
>
> how about a mail merge type operation? is that possible from non ms
> clients? could i write a csv file with addresses and a couple fields to
> merge and expect a home user to be able to merge that with a message
> template to send mail easily??
>
> or is the imap interface general enough to use with various clients? i
> haven't looked at that much because it appears to want to connect to the
> mail server which i would rather stay away from if possible. or is there
> some other message generating interface that is generic enough to use??
>
>

Relevant Pages

  • Re: Email client programs
    ... I finally cured myself of kitchen-sink email clients. ... You need the full control email model. ... You can control the deletion of the message at the POP3 server with the ...
    (Debian-User)
  • Re: Writing text to a form record permanently
    ... field you see displayed comes from the combo's RowSource query. ... Create a new control on the form and bind it to the "visible" field. ... There is a drop down list of active clients to choose from. ... > I wan't the persons name to appear on the time card record even after I ...
    (microsoft.public.access.gettingstarted)
  • Re: Database Wizard
    ... Let Your Clients Control Their Content With Just A Browser! ... >> Let Your Clients Control Their Content With Just A Browser! ... >>> purchaser, similar to a guestbood I think. ... I'm sure my boss will want me to add ...
    (microsoft.public.frontpage.programming)
  • sending mail from vba with unknown client software
    ... no answer to the query about the 255 character limit on control's ... have no control over mail clients nor mail servers used. ... where i have done this before and had control of an smtp server i have put ...
    (microsoft.public.office.developer.vba)
  • Re: Inheriting from UserControl...
    ... then I submit that you don't want to just expose ... If we're taking the position buttons user control as an example, ... A "position" enumeration: TopLeft, MiddleLeft, BottomLeft, etc. ... it's bad form to allow clients to see inside your UserControl and get ...
    (microsoft.public.dotnet.languages.csharp)