Email

[BukHix]

I have seen the Access 2000 SendObject problem come up quite a bit on message boards so I think it is a pretty common problem. I am not sure if this is any help at all but here it is anyway: ACC2000: SendObject Method Fails in Access 2000

Good Luck

 

[Hayley Baxter]

I'll have a look, thanks very much for your help once again.

Much appreciated
Hay

 

[Graham Bucknall]

user defined type not defined

I tried the simple approach to send a bulk email to a list of people from a query and used:

---
Private Sub Command0_Click()

Dim rsEmail As DAO.Recordset
Dim strEmail As String
Set rsEmail = CurrentDb.OpenRecordset("qryEmailList")

Do While Not rsEmail.EOF
strEmail = rsEmail.Fields("email").Value
DoCmd.SendObject , , , strEmail, , , "Subject", "Message Text"

rsEmail.MoveNext

Loop
Set rsEmail = Nothing

End Sub
---

When I run it I get "user defined type not defined".

I am sure it is something simple but I'm not sure what?

Can anyone help?

 

[BukHix]

Graham check your references to make sure that DAO is checked and that you don't have any shown as missing. You can check references by opening a module and then going to the menu under Tools > Reference.

 

[Graham Bucknall]

Thanks

Many thanks - I knew it was soemthing simple. It all works fine now.

 

[orbic1]

Hi Hayley et al,

This has been of much use! Could you post your DB with those amendments in it? Thanks - I'm having problems doing the same sort of thing.

 

[Thales750]

This thread was very helpful so i decided to move it up 5 years.