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_to_s...@yahoo.com ________________________________ From: bpascal123 <bpascal...@gmail.com> To: excel-macros@googlegroups.com Cc: Subu S <mail_to_s...@yahoo.com> 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 30/11/2012 45678.45 PO Box 322,Madras fancy...@hotmail.com >68203.83 > > > > >For one customer, using Word Mail Merge, the data for one customer must be >like above... Your data is also a bit difficult to deal with, to implement it >there might be changes in the account info sheet as invoice AX4653 comes with >multiple invoice date, due date and amount due. Maybe it's a typo because for >one invoice, there should only be be one invoice date... unless you have >specific requirements... > > >Once your data is laid like that you can start the mail merge from Word. The >header fields as shown above should help Word match its mail merge fields as >there may be some confusion using an incremental number invoiceNum_1, >invoiceDate_2... in relation to the column position of each field... > > >My issue using mail merge comes when invoice information are displayed in a >table or in a tabular way following your letter layout. There Word mail merge >decides of the number of rows in the table from the customer that has the >maximum number of due invoices. Everyone else will have a table size of this >customer. I'm not an expert of Mail Merge but maybe there is an option >somewhere that makes Word adjusts the number of rows in the mail merge tool >accordingly to the number of real invoices for one customer, in your data, it >seem there is the same number of invoice for each customer ... if one day a >customer has ten invoices, there will be 10 rows on every table... At this >stage, I have deleted manually all empty rows while checking every letters... >If the number of letters is significative, this might be difficult... > > >Is anyone aware of something to do to "fix" this? I would think of a macro >that would loop through every table and delete empty rows once the mail merge >is complete. Else, coding with vba the Word mail merge instead of doing it >manually from the tool bar might allow ... >Show original -- 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. -- 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.
