Search results

Good morning guys. I have a small aplication that sends emails with pdf reports attached. It has litte bit of everything but there is a memo type field that depending on the format of the text (When there are tabs specially) overlaps the begining of the text on each line. When you preview the...

I will try that, seems a little more flexible that the sendobject. I guess I need to export as many reports as email alerts I am sending. Thanks Paul.

It seems like I could replace my sendobject by CDO.Message but I am not sure if it will work with exchange...

Yup I looked at the redemption too but it seems way to complicated and not too safe. I will take a look at the ClickYes one. No idea what CDO is at all : ) Thank you guys

Great I used Paul's option and it is working great. The last detail is the "A program is trying to send an e-mail on your behalf..." I look around and I believe there is no way to disable this security warning... Am I right?

Do you think is difficult to open a dialog window if there are no null values saying something like "No new incidents" or something?

Yup it is. I was trying to use a query instead of a table as a recordset but it did not let me record the sent date. Thanks again.

It worked great! Thank you Paul!

Hello, I am trying to add a filter to a recordset table but I am not sure how to write ir or in what part of the code. This is my code: Dim RS As DAO.Recordset Set RS = CurrentDb.OpenRecordset("Mail_Reminder_RecordSet") With RS If .EOF And .bof Then 'IT MEANS THERE ARE NO RECORDS, WE ARE AT THE...

I downloaded the trial and I was disapointed because it does not work with Outlook.

Thanks a lot. You were right. I created a text box and named IncidKey and it works like a charm. It is amazing how little I know about access and how much I can do with your help. Thanks

Thanks for the answer. Well I know what happened but I do not know how to fix it. The filter is working but it changed all the IncidKey records on my table to the first one. I have a warning when I close the form after I send the mails saying "Write Conflict, The record has been changed by...

Paul, I think I talked too fast. For some reasson it stop filtering the reports. It did work for a while but now it just sends the same report to all the emails adresses. Do you know what could be wrong?

Pbaldy thank you so much for your help. This is working great now! I am so happy :D John Big Booty, thanks for your help too, I tried the other option first because it looked easier but I am sure your option was as good too.

Great, thank you for the advise I will try both options tomorrow and let you know what happens.

Thank you both. I just left the office, but I will try that tomorrow morning. Thank you again for the help. pbaldy, I am not sure I understand what do you mean. I really have no experience with VB. Could you tell me how to set the loop to my value? Thank you, thank you

Hello everybody, I am trying to create a form that sends mail alerts with a filtered report for each person. I have been using some code I found online. This is my problem, right now it is sending the mails and it is filtering the report but only filter the same records, after the first mail...