Search results

Works fine now... Thank you!

Here you are .... I want to add a line with some text after it lists the name & department of the people... strTo = "sunramkissoon@apolloblake.com" strSubject = "Birthday Notification" strBody = "Hi Everyone," & vbNewLine & vbNewLine & "This is to inform you that the following people...

Hi Paul, My Code ends like this. I want to add a new line after access displays all the names of the people celebrating their birthdays. I tried add a new line using some vbNewLine codes but nothing happens!!! How can the code be twisted so that I can add an ending phrase into the email...

If you want to create a report just to display 'RHICHOP', create a query and add the field for program. Under criteria, type "RHICHOP", it will call out information only when program is 'RHICHOP'. If you want to add this to your report, under the title Program, in the information box, just...

Try doing it this way =IFF([Program]='RHICHOP',"RHICHOP",0). Then you do conditional formatting and make the field equal to '0' not visible. This should work fine. This is just a simple way and quick turnaround but think others might have other strong input ;)

Thank you Paul - This works perfectly fine. I think you omitted some fields in the code just for testing - LOL :D But i was able to figure out.... When writing the code for the second recordset, it should be rs2 - But i got it right - Thanks a Lot ;)

So means that same module should be used??? If so, my codes end like this... Loop DoCmd.SendObject To:=strTo, Subject:=strSubject, MessageText:=strBody, EditMessage:=False End If Set rs = Nothing Set db = Nothing End Function How to go around setting up another code in...

Hey Everyone, One more Question!!! What if I need to send another email like this but containing information different than that of DOB - Let's say, I want access to also send email notifications regarding someone completing their One Year within the Organization? Do I need to create...

Issue Resolved by Downloading ClickYesPro 2010 :)

Hi Everyone, I am using MS Access and I have set up a macro to automatically send an email upon an occurrence. I want to set up the emailing system automatically without any user interaction. My Access Database is working on fine and the email are being sent. My problem is that each time...

Thanks Nigel - Issue Resolved :)

Thank you Paul. I know where my mistake was and everything is set now. Thank you so much. It certainly helped me a lot. Just a concern now - Like I said, my database is split into back-end and front-end. They are both saved in the sharedrive. I am always connected to the server and my...

Hi Paul, Not, whatever you mentioned was very helpful but I am not able to use the time interval to send the report. Like i said, my database is always open and i want the email to be sent at a given time without having someone to open and close the database everyday. I am sorry but this...

Hi Nigel, I am just trying this to do it your way. I wrote the module and everything is fine. Can you guide me how to call for this? Do i need to use AutoExec here?

Hi, I have set up a query to send birthday email notifications one day before the occurrence. Everything is good with this. I have set the AutoExec to send the email and it is working fine. My problem is that :banghead: AutoExec works only when you open the Database. My Database always stays...

Thank you Nigel, What if I want the email body to be several lines. Ex. Hi Managers, I would like to inform you that the following people will be celebrating their Birthday Tomorrow: Name1 Name2 The above is my first question and second one is below... Let's say, I want to add their Age/...

Great Paul - This works as well :) More one Question came to my mind - I have set a AutoExec Macro to execute this and send the email. My Database will be split into Back-End and Front-End. My Front-End will always remain open. Will i still receive the email? Or does someone need to close and...

Hey Paul, Thanks for pointing out these two. It actually working now. :) I also needed to add a no to that the email goes automatically... Proper Code for this will be: DoCmd.SendObject acSendNoObject, , , strTo, , , strSubject, strBody, no You're Right Paul - That will be a Good Question...

Hi Everyone, To make it simple, I will be using a simple example. I have a Table with PersonName and DOB. I want access to send me email notification one day before someone's birthday. I have set up the query accordingly. I have a problem with my code and saying something about 'Syntax...

Greeting Everyone, I am new to this site and hoping we can share some of our knowledge and make the most out of it. Thanks, Sunny