i partly agree... it does depend on the ledger and the kind of business If I'm chasing for a high amount monthly service payment for which reminders were sent by email but the contact is not directly available by phone at least to set a payment date or schedule, a postal letter with receipt is the last action before the case goes on further to collection companies. In this case, if the client can be found by postal means and has accepted to sign the receipt for a letter that can be of any origin for him and until he can read the service will be stopped if pending transactions are not paid... it's then easy to stop the service if nothing follows. If the service provided is crucial for the continuity of the business of the client, it's likely a response will follow. Letters with receipt allow to make that distinction. I acknowledge this is something that has to be done at last resort... and it depends on many aspects such as country culture, business to business, business to consumer transactions...
On Friday, December 28, 2012 6:17:32 PM UTC, .. wrote: > > Dear pascal > > > My rule : > =============== > > 1. bad / terrible customer -> proof ... Signature ... Etc > > 2. Most normal customers and even late payers but honest payers : email. > Fast gets the job done without fuss > > Also please note that e commerce legislation is improving by the day and > all the green ( don't print ) thinking is moving heavily in this direction > of e mail statements and reminders > > Check with your company lawyers on agreements with customers on how to > bind them to accept e statement and e reminders > > You will be amazed at the new thinking > > Even banks have implemented this !!! > > > > > -- > > Regards > Subu > > > mail_t...@yahoo.com <javascript:> > ------------------------------ > *From:* bpascal123 <bpasc...@gmail.com <javascript:>> > *To:* excel-...@googlegroups.com <javascript:> > *Cc:* Subu S <mail_t...@yahoo.com <javascript:>> > *Sent:* Friday, 28 December 2012, 5:12 > *Subject:* Re: $$Excel-Macros$$ Re: Mail merge and E mail : Reminder > email to customers using VBA > > I agree I was confused about your requirement. I'm currently working as an > AR accountant / credit-controller and in many cases, a postal letter sent > with a receipt (a receipt is the proof the postman has either handed the > letter to the recipient or if the recipient is not present when the post > man delivers mails, left a notification about a letter to pick-up at his > local post office). Following usual rules, until he picks-up, the recipient > is not aware of the originator or where the mail is from. So even if a > letter takes longer, in the end you have a solid proof the person you have > sent the letter to has gotten it.. > > On Thursday, December 27, 2012 7:57:35 PM UTC, .. wrote: > > Dear Pascal > > Thanks for the responses. I am reply each response separately so as not to > confuse other readers > > I can NOT use Paper mail / snail mail or postal mail as you mail call it > > Unfortunately postal mail is NOT fast enough, takes many days to reach > (customers at) other places, and IF the customer faces a discrepancy it > takes again a lot of time for him to respond via another postal mail > ....so I am forced to use fax or e mail for instant reminders; I > explained the problem with fax earlier, so the only option left is e mail > > I think others have understood this correctly. Yes I am requesting a way > to e mail these letters > > I shall answer your other suggestion to change the VBA in the next mail > > > -- > > Regards > Subu > > > mail_t...@yahoo.com > ------------------------------ > *From:* bpascal123 <bpasc...@gmail.com> > *To:* excel-...@googlegroups.com > *Sent:* Wednesday, 26 December 2012, 23:38 > *Subject:* $$Excel-Macros$$ Re: Mail merge and E mail : Reminder email to > customers using VBA > > > Hi, > > Happy new year and all... About your query it seems you have 2 queries, > one related to mail merge (paper) and one to email. I have been working on > these for my own needs, with more or less access to the content... > > For mail merge using email, it seems there are many resources available > online to automate emails from Excel to Outlook with customs email > addresses, subject, body and so on > > For mail merge using paper (for faxing or post mailing), most available > infos is about Word and its mail merge tool. For that, at this time, I have > just managed to make the data "fit" the mail merge tools, like > > *Customer#* > *Customer_name* > *invoiceNum_1* > *invoiceDate_1* > *invoiceDueDate_1* > *InvoiceDueAmt_1* > *invoiceNum_2* > *invoiceDate_2* > *invoiceDueDate_2* > *InvoiceDueAmt_2* > *…* > *invoiceItem_8* > *address* > *email* > *Total Dues* > 12345 > The fancy paint shop > AX4562 > 2012-01-10 > 30/11/2012 > 11289.6 > AX4653 > 2012-02-10 > <td width="98" nowrap="" valig... > Show > original<https://groups.google.com/group/excel-macros/msg/c478d80069ed8446?dmode=source&output=gplain&noredirect> > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
