how do u send an email using access?

[DP]

hi,

is there a way to send an e-mail to a customer, using ms access?? or some
kind of automated mail merge, so the user only has to review the body, and
click send?

ive got a customer table, with a field called email address, where the
customer can have an e mail address.

is there a way to make access create one, using outlook express, or anything
similar??
i just wanted to create some kind of reminder e mail, to say, please bring
yor rented film back to the store.

does any1 know of any sites, advice?

TIA

dev

[fredg]

On Sat, 18 Feb 2006 17:49:55 GMT, DP wrote:

hi,

is there a way to send an e-mail to a customer, using ms access?? or some
kind of automated mail merge, so the user only has to review the body, and
click send?

ive got a customer table, with a field called email address, where the
customer can have an e mail address.

is there a way to make access create one, using outlook express, or anything
similar??
i just wanted to create some kind of reminder e mail, to say, please bring
yor rented film back to the store.

does any1 know of any sites, advice?

TIA

dev

DoCmd.SendObjec t acSendNoObject, , acFormatTXT, [EmailAddressFie ld], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

Look up the SendObject method in VBA help.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Tim Marshall]

fredg wrote:

DoCmd.SendObjec t acSendNoObject, , acFormatTXT, [EmailAddressFie ld], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

One irritating thing the help file does not tell you is that sendobject
DOES NOT WORK PROPERLY with netscape as the default mail client. It is
unable to fill in the to header and unless you have the email generated
so that you can physically add it in, it won't send a blinking thing.

This problem is with Access 2003 Sp2 and Netscape 7.2.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[DP]

hi,

i've put the code u gave me, and it all comes out in RED writing.

the email addess field is called EMailAddress which is in an
overduefilmquer y called qryOverdueFilmR entalQuery

the code u gave me seems correct, but there is some kind of systax error or
something? if i can just get this email working, i can can add my own
fields/data in it.

thanx

dev

"fredg" <fg******@examp le.invalid> wrote in message
news:fe******** *************** *****@40tude.ne t...

On Sat, 18 Feb 2006 17:49:55 GMT, DP wrote:

hi,

is there a way to send an e-mail to a customer, using ms access?? or some kind of automated mail merge, so the user only has to review the body, and click send?

ive got a customer table, with a field called email address, where the
customer can have an e mail address.

is there a way to make access create one, using outlook express, or anything similar??
i just wanted to create some kind of reminder e mail, to say, please bring yor rented film back to the store.

does any1 know of any sites, advice?

TIA

dev

DoCmd.SendObjec t acSendNoObject, , acFormatTXT, [EmailAddressFie ld], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

Look up the SendObject method in VBA help.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[DP]

hi,

this is wat ive got so far;

Private Sub cmdFilmMail_Cli ck()

DoCmd.SendObjec t _
, _
, _
, _
"To****@doe.com ", _
, _
, _
"Blockbuste r Team - You have an Overdue Film Rental", _
"Dear Sir/Madem, You have an over film rental. Pleas could you return it
to your nearest blockbuster store.", _
True
End Sub

is there a way to link the email address field, to a field in my query? as
mentioned in the post before.
also i want to do the same, with the name (after the dear bit) and state the
'FilmID' 'FilmTitle' from the metioned query, into the email message.
the above code, opens an email message, ready to send.
thanx

dev
"DP" <[e-mail] > wrote in message
news:O5******** **********@news fe6-gui.ntli.net...

hi,

i've put the code u gave me, and it all comes out in RED writing.

the email addess field is called EMailAddress which is in an
overduefilmquer y called qryOverdueFilmR entalQuery

the code u gave me seems correct, but there is some kind of systax error or something? if i can just get this email working, i can can add my own
fields/data in it.

thanx

dev

"fredg" <fg******@examp le.invalid> wrote in message
news:fe******** *************** *****@40tude.ne t...

On Sat, 18 Feb 2006 17:49:55 GMT, DP wrote:

hi,

is there a way to send an e-mail to a customer, using ms access?? or some kind of automated mail merge, so the user only has to review the body, and click send?

ive got a customer table, with a field called email address, where the
customer can have an e mail address.

is there a way to make access create one, using outlook express, or anything similar??
i just wanted to create some kind of reminder e mail, to say, please bring yor rented film back to the store.

does any1 know of any sites, advice?

TIA

dev

DoCmd.SendObjec t acSendNoObject, , acFormatTXT, [EmailAddressFie ld], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

Look up the SendObject method in VBA help.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Bernard Peek]

In message <dt**********@c oranto.ucs.mun. ca>, Tim Marshall
<TI****@PurpleP andaChasers.Moe rtherium> writes

fredg wrote:

DoCmd.SendObjec t acSendNoObject, , acFormatTXT, [EmailAddressFie ld], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

One irritating thing the help file does not tell you is that sendobject
DOES NOT WORK PROPERLY with netscape as the default mail client. It is
unable to fill in the to header and unless you have the email generated
so that you can physically add it in, it won't send a blinking thing.

This problem is with Access 2003 Sp2 and Netscape 7.2.

I've seen the same problem using Access 2000 and Turnpike as the mail
client. I suspect that it may only work with Outlook.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

[DP]

i sorted it, it it works perfectly!! damn i'm so good!!

thanx for all the help. :)

dev

"DP" <[e-mail] > wrote in message
news:Sb******** **********@news fe2-gui.ntli.net...

hi,

this is wat ive got so far;

Private Sub cmdFilmMail_Cli ck()

DoCmd.SendObjec t _
, _
, _
, _
"To****@doe.com ", _
, _
, _
"Blockbuste r Team - You have an Overdue Film Rental", _
"Dear Sir/Madem, You have an over film rental. Pleas could you return it to your nearest blockbuster store.", _
True
End Sub

is there a way to link the email address field, to a field in my query? as
mentioned in the post before.
also i want to do the same, with the name (after the dear bit) and state the 'FilmID' 'FilmTitle' from the metioned query, into the email message.
the above code, opens an email message, ready to send.
thanx

dev
"DP" <[e-mail] > wrote in message
news:O5******** **********@news fe6-gui.ntli.net...

hi,

i've put the code u gave me, and it all comes out in RED writing.

the email addess field is called EMailAddress which is in an
overduefilmquer y called qryOverdueFilmR entalQuery

the code u gave me seems correct, but there is some kind of systax error

or

something? if i can just get this email working, i can can add my own
fields/data in it.

thanx

dev

"fredg" <fg******@examp le.invalid> wrote in message
news:fe******** *************** *****@40tude.ne t...

On Sat, 18 Feb 2006 17:49:55 GMT, DP wrote:

> hi,
>
> is there a way to send an e-mail to a customer, using ms access?? or

some

> kind of automated mail merge, so the user only has to review the

body, and

> click send?
>
> ive got a customer table, with a field called email address, where

the > customer can have an e mail address.
>
> is there a way to make access create one, using outlook express, or

anything

> similar??
> i just wanted to create some kind of reminder e mail, to say, please

bring

> yor rented film back to the store.
>
> does any1 know of any sites, advice?
>
> TIA
>
> dev
DoCmd.SendObjec t acSendNoObject, , acFormatTXT, [EmailAddressFie ld], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

Look up the SendObject method in VBA help.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Bernard Peek]

In message <UZ************ *******@newsfe6-win.ntli.net>, DP
<[e-mail] > writes

i sorted it, it it works perfectly!! damn i'm so good!!

How?

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

[DP]

well it works if u have outlook express installed. i tried it on my m8s pc
today, and some msn 'passport' screen loads up, and then crashes. (Cos he
does not have outlook express)

is there anyway to check this? or to stop it from crashing?

i've got the code i'm using at the mo, if u want it?

thanx

devin
"Bernard Peek" <ba*@shrdlu.com > wrote in message
news:9Y******** ******@shrdlu.c om...

In message <UZ************ *******@newsfe6-win.ntli.net>, DP
<[e-mail] > writes

i sorted it, it it works perfectly!! damn i'm so good!!

How?

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

[Fred Zuckerman]

"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtherium> wrote in message
news:dt******** **@coranto.ucs. mun.ca...

fredg wrote:

DoCmd.SendObjec t acSendNoObject, , acFormatTXT, [EmailAddressFie ld], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

One irritating thing the help file does not tell you is that sendobject
DOES NOT WORK PROPERLY with netscape as the default mail client. It is
unable to fill in the to header and unless you have the email generated
so that you can physically add it in, it won't send a blinking thing.

This problem is with Access 2003 Sp2 and Netscape 7.2.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Also, with A2K, make sure you are using SP-3. There were some SendObject
bugs that MS fixed. Unfortunately for me, I have a client that bought a huge
& expensive software package from a firm that evidently wrote it for MS
Office SR-1. They claim that their warranty voids if they load any newer
patches. Thus my client won't load SP-3 (for fear that their expensive
software might crash) and thus my little A2K emailing project won't work for
them. Instead, they've asked me to change my database to print a report and
they will fax it daily to the 10 people that need it. How silly :(
Fred Zuckerman