I have a requirement to mail merge to text files. For example, if I have a CSV like this:
=========================
Date,Sehri,Fajr,Sunrise,Zawal,Asr,Asr[H],Maghrib,Isha
1,05:29,05:34,06:56,12:12,15:08,15:51,17:30,18:50
2,05:29,05:34,06:56,12:12,15:08,15:52,17:31,18:50
3,05:29,05:34,06:56,12:12,15:09,15:52,17:31,18:50
4,05:29,05:34,06:56,12:12,15:09,15:52,17:31,18:50
5,05:29,05:34,06:56,12:12,15:09,15:53,17:32,18:51
=========================
And then create a merge document something like this:
=========================
:: Salaah Times Reminder:: In 10 Min it will be Fajr in Johannesburg on 1 July 07, Fajr 05:34, Sunrise 06:56. Jazakallah
:: Salaah Times Reminder:: In 10 Min it will be Zuhr in Johannesburg on 1 July 07, Zuhr/Zawal 12:12. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Asr in Johannesburg on 1 July 07, Asr 15:51. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Maghrib in Johannesburg on 1 July 07, Maghrib 17:30. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Esha in Johannesburg on 1 July07, Esha 18:50. Jazakallah
**
:: Salaah Times Reminder:: In 10 Min it will be Fajr in Johannesburg on 2 July 07, Fajr 05:34, Sunrise 06:56. Jazakallah
:: Salaah Times Reminder:: In 10 Min it will be Zuhr in Johannesburg on 2 July 07, Zuhr/Zawal 12:12. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Asr in Johannesburg on 2 July 07, Asr 15:52. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Maghrib in Johannesburg on 2 July 07, Maghrib 17:31. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Esha in Johannesburg on 2 July 07, Esha 18:50. Jazakallah
======================
The Completed Text file should have 5 lines per day. (there is 5 lines per day above). Everything should be in one Text file.
=========================
Date,Sehri,Fajr,Sunrise,Zawal,Asr
1,05:29,05:34,06:56,12:12,15:08,15:51,17:30,18:50
2,05:29,05:34,06:56,12:12,15:08,15:52,17:31,18:50
3,05:29,05:34,06:56,12:12,15:09,15:52,17:31,18:50
4,05:29,05:34,06:56,12:12,15:09,15:52,17:31,18:50
5,05:29,05:34,06:56,12:12,15:09,15:53,17:32,18:51
=========================
And then create a merge document something like this:
=========================
:: Salaah Times Reminder:: In 10 Min it will be Fajr in Johannesburg on 1 July 07, Fajr 05:34, Sunrise 06:56. Jazakallah
:: Salaah Times Reminder:: In 10 Min it will be Zuhr in Johannesburg on 1 July 07, Zuhr/Zawal 12:12. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Asr in Johannesburg on 1 July 07, Asr 15:51. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Maghrib in Johannesburg on 1 July 07, Maghrib 17:30. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Esha in Johannesburg on 1 July07, Esha 18:50. Jazakallah
**
:: Salaah Times Reminder:: In 10 Min it will be Fajr in Johannesburg on 2 July 07, Fajr 05:34, Sunrise 06:56. Jazakallah
:: Salaah Times Reminder:: In 10 Min it will be Zuhr in Johannesburg on 2 July 07, Zuhr/Zawal 12:12. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Asr in Johannesburg on 2 July 07, Asr 15:52. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Maghrib in Johannesburg on 2 July 07, Maghrib 17:31. Jazakallah
:: Salaah Times Reminder:: In 10 Minutes it will be Esha in Johannesburg on 2 July 07, Esha 18:50. Jazakallah
======================
The Completed Text file should have 5 lines per day. (there is 5 lines per day above). Everything should be in one Text file.