Marcin wrote:
Hello all!
A few years ago I created a form with button which let me send an email
with an attachment. It was created in Access 97. Now I would like to
move this application into Access 2003. But when I did it, sending email
code doesn`t work. Can you be so kind and give me the code how to send
email with and without attachment in vb in Access 2003??
If you are using anything other than Outlook as your email client you
may be experiencing problems as a result. For example, I use Netscape
7.x. When the sendobject method is used (which was also tempermental in
A97, though not like it is in A2003) in A2003 and the email client is
Netscape 7.x, the "to" addresses are not transmitted to the email. So I
too found that A2003 did not send anything. If you set your editmessage
argument to true, you will see the email generated without the addresses.
I wouldn't know what to do if you need to do large amounts of emailling,
but in my recent app where there was a small number of emails setn, I
developed an email procedure which opened a form with all the subject,
to, body arguments. A send button also copied the to addresses to the
clipboard (I used an API proceudre to do this) and involed the
sendobject action with editmessage set to true. It is then just a
matter of pasting the address(es) in the 'to' field and sending.
But as I said, for mass emailling - I don't know.
--
Tim
http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me