Recent content by Work

Hello again. Here is the best I can do to send something along. For some reason I can't attach anything. Private Sub Command28_Click() On Error GoTo Err_Command28_Click Dim EmailStr As String EmailStr = DLookup("Email", "Addresses", "Street=Street") DoCmd.OpenReport "letter"...

Does anyone else have a suggestion on what I should do? I still can't get it to work. I think I'm just missing it and tried everything that I know what to do. Thanks. As far as posting my DB its too big. I tried the database file itself and even tried to zip it and said that it was too big.

Mmm. I tried to attach it and said my file was too big. So I zipped it and it was too big. I don't know how else to attach it then.

Anyone else I have been messing with this and still can't get it to work. I messed around with Nero's sugestion and then it did not work. So I just used EmailStr = DLookup("Email", Addresses") And took the rest off. The good news is that it worked but the bad news is that no matter what...

Reposnse Thanks Nero. But Unfortunetly I get this error. The Expression you entered as a query parameter produced this error: 'The object doesn't contain the automation object E" What does that mean?

I have a question. Right now I have two tables ones called Master and the other Addresses. In the Master I have all my data that goes into it. The Addresses table is a list of Principals and there address and now e-mail. I then made a query called Letters+Addresses. I have the Master table...