Hii…
was testing through the cron function in windows. Steps done:
Set up scheduled task to call the cron page at a certain point of time in a day (say at 9 PM)
This sends email successfully to patients having appointments in the next 24 hrs automatically to the email address in the patient’s demographics. (The email sending feature is absolutely perfect and tuned by using mercury mail)
before sending mail, I did setup the automatic_notification table in the database and wrote the body of the message/email in the table itself.
screenshot of the database automatic_notification table:
I have added enough space and paragraphs in the automatic_notification table in the database, but when the email appears in my gmail inbox, it shows like this:
If paragraphs and spacing is the only issue, you could look at adding php encoding for lines. Make sure the cron job translates it correctly.
As suggested earlier, you can also use any html editor to create your message. Simple html body is attached for starters. It may contain some tags that are not standard but it will give you some idea. Once you are satisfied with the layout and appearance, copy and paste raw html code in the table and test.
Thank you MD support, I was unable to test because the email function doesnt seem to work in cronjob and batch com. have made a new topic regarding that issue in this developer forum.
Thank u MD Support…after fixing my Email function from Mercury Mail…I tested your script for automatic notification. It is brilliant…solved all my issue…Thank you so much.
