Is there a way to specify the column width so the email appears more like a table?
On Wednesday, December 26, 2012 at 11:00:57 PM UTC-5, Anoop K Sharma wrote: > > Hi Subu, > > In attached file you can see another sheet added with images describing > the solution to your problem. > Open this workbook press Alt+F11, you will get the editor window (images > are attached) and add this library (As per the instruction in images). > > You need to change email Ids on "Merged Data Sheet". > Open outlook and run the program. > > Regards, > Anoop > Sr Developer > > > > On Wed, Dec 26, 2012 at 6:23 PM, Subu S <mail_t...@yahoo.com <javascript:> > > wrote: > >> Dear Anoop >> >> Thanks for the efforts. Much appreciated >> >> When I have copied, pasted customer names etc, yes changed the e mail to >> my own (for test) and copied paster invoices, I get an error and get stuck >> .... Screen shot of error is enclosed >> >> Screen shot of what I see uploaded here here >> http://www.flickr.com/photos/83767154@N03/8310676618/in/photostream >> >> shorturl for uploaded image http://bit.ly/VcBHd6 >> >> I use Outlook 2003. The application is open when I hit the "Send mail" >> button >> >> The XL file is saved before I get the "send mail" button >> >> >> >> -- >> >> Regards >> Subu >> >> >> mail_t...@yahoo.com <javascript:> >> ------------------------------ >> *From:* Anoop K Sharma <aks.sh...@gmail.com <javascript:>> >> *To:* excel-...@googlegroups.com <javascript:> >> *Sent:* Wednesday, 26 December 2012, 13:16 >> >> *Subject:* Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email >> to customers using VBA >> >> Hi Subu, >> >> I have built up something like you needed. All the information of >> customers and their accounts have been pasted on two different sheets of >> attached workbook. Also, I have added another sheet named as "Merged Data" >> which combines both record for mail merge purpose. >> >> >> You need to click a command button on "Merged Data" Sheet. >> *Make sure to change email addresses on this sheet as it'd shoot mail to >> the customers mentioned there.* >> >> >> Your further requirement is still pending as this has to be verified by >> you for fulfilling your purpose. >> >> Regards, >> Anoop >> >> >> On Tue, Dec 25, 2012 at 8:54 PM, Subu S <mail_t...@yahoo.com >> <javascript:>> wrote: >> >> Thanks Anoop for the reply. Appreciate your concern >> >> ////Are you having invoices info and customer info in different >> workbooks?///// >> >> All the Customer master info would be on one sheet [one sheet only ] and all >> the invoices would be on another sheet [one sheet only ] >> >> If need be I can make them two sheets of one workbook or keep them as two >> different files, that is optional and please take the course that is >> easiest for you >> >> The need is : >> >> - Each e mail is to be sent to the respective customers e mail >> - Some customers may have multiple e mail , I will add them in the e >> mail field on the customer master with a coma or whatever seperator you >> suggest >> - Each e mail [body of email ] should have the customers basic >> address info as in sample >> - Each e mail [body of email ] should have a common format , dear sir >> / madam ...... please effect payment ....etc tc but the data (like total >> overdue value and list of invoices would vary) >> - Also, I hope to have some flexibility to change the text on the >> email [for example when I am on leave some one elses e mail and so on ] >> ...this I will do by modifying your VBA at the appropriate place >> >> >> the rest is up to you to choose and tell me to do / follow >> >> >> -- >> >> Regards >> Subu >> >> >> mail_t...@yahoo.com <javascript:> >> ------------------------------ >> *From:* Anoop K Sharma <aks.sh...@gmail.com <javascript:>> >> *To:* excel-...@googlegroups.com <javascript:> >> *Sent:* Monday, 24 December 2012, 10:00 >> *Subject:* Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email >> to customers using VBA >> >> Hello Stranger, >> >> I can see your query and would like to get it done but before doing this >> I am curious to know something related to your query. >> Are you having invoices info and customer info in different workbooks? >> If yes then In attached Sample list of Invoicing, I can see only few >> inputs. Are these information available only one sheet or more than one >> sheet. I put the same question on the other attached workbook (customer >> Master). >> >> or it would be good idea if these information is put on same workbook. >> >> Regards, >> Anoop >> Sr. Developer >> >> >> On Wed, Dec 19, 2012 at 4:45 PM, .. <mail_t...@yahoo.com <javascript:>> >> wrote: >> >> Dear List members >> >> Request : *Mail merge and E mail* using VBA or other tools >> ================================================================= >> >> - I have to send reminder / dunning letters to my customers. >> - Unfortunately the faxing option from the company is very time >> consuming (print, sort, fax, wait for dial tones...failure etc etc) and >> it >> takes a long time. >> - Also there isn't a corporate e mail reminder solution in sight. >> - To avoid delays and very heavy workload, I plan to e mail the >> reminder / dunning letters. *I have to take this personally * >> - I think this should be possible to partially automate this task >> using XL (data) and combining that with word or VBA and send mail thru MS >> outlook. >> - I suspect some one may have tried this before >> - I seek your help for innovative solutions...either VBA or any other >> innovative solution as well . >> - All input data would be available as XL files. Samples shown below >> and XL files also added to this mail >> - If this has not been tried earlier or if this is too cumbersome, >> please drop this, ...my advance apologies . >> - Any pointers to other websites are also gratefully acknowledged >> >> >> >> THANKS in advance !!! >> >> Subu >> >> >> My customer master looks like this *[xl file enclosed]* >> ======================================== >> >> Customer#........Customer_Name...........Address......................E_mail....... >> >> 12345............The fancy paint shop....PO Box 322, >> madras...........fancy_pa...@hotmail.com >> 12346............Bright Colours.............PO Box 123, >> cochin............bright_col...@gmail.com >> 12347............Best Decor Bangalore..PO Box 456, >> bangalore........best_d...@bestbangl.co.in >> ....and ...so on ..... >> >> >> >> My list of overdue invoices looks like this *[xl file enclosed] * >> =================================================== >> Customer >> #........Invoice#.......InvoiceDate.........DueDate........Amount_Due(Rs) >> >> 12345.............AX4562.........01/10/2012.........30/11/2012......11289.60 >> >> 12345.............AX4653.........02/10/2012.........30/11/2012......45678.45 >> >> 12345.............AX4653.........02/11/2012.........31/12/2012......11235.78 >> >> 12346.............AX8657.........04/10/2012.........30/11/2012.......4567.60 >> >> 12346.............AX7658.........07/10/2012.........30/11/2012.......3456.45 >> >> 12346.............AX9248.........08/11/2012.........31/12/2012.......2589.78 >> >> 12347.............AX4258.........06/10/2012.........30/11/2012.....111269.60 >> >> 12347.............AX4796.........12/10/2012.........30/11/2012......33789.45 >> >> 12347.............AX6987.........10/11/2012.........31/12/2012........560.78 >> .......and so on .... >> >> >> >> I wish to send a reminder / dunning letters by e mail as follows >> ========================================================================== >> >> >> ======= start of 1st reminder email to fancy...@hotmail.com <javascript:> >> ====== >> >> To >> M/s Fancy Paint Shop => >> PO Box 322 => >> Madras => all above from the master ! >> >> Date : 19 Dec 2012 (basically run date) >> >> Dear Sir, Madam >> >> You account is overdue by Rs. 56,968.05. Please effect payment >> immediately to avoid delays in supply. A list of invoices due on your >> account is given below >> >> Customer >> #........Invoice#.......InvoiceDate.........DueDate........Amount_Due(Rs) >> >> 12345.............AX4562.........01/10/2012.........30/11/2012......11289.60 >> >> 12345.............AX4653.........02/10/2012.........30/11/2012......45678.45 >> >> Should you need anything more please contact Subu at ......@yahoo.com or >> at +98354xyzab for further information >> >> Thanking you >> Yours Sincerely >> >> Subu >> ======================= end of 1st dunning email ======================= >> >> As you would have noticed the next reminder / dunning letter would be of >> the same format but different in the due amount and list of invoices >> >> >> >> ========= Start of 2nd reminder / dunning email to bright...@gmail.com >> <javascript:> ======= >> >> >> To >> M/s Bright Colours => >> PO Box 123 => >> Cochin => all above from the master ! >> >> Date : 19 Dec 2012 (basically run date) >> >> Dear Sir, Madam >> >> You account is overdue by Rs. 8024.05. Please effect payment immediately >> to avoid delays in supply. A list of invoices due on your account is given >> below >> >> Customer >> #........Invoice#.......InvoiceDate.........DueDate........Amount_Due(Rs) >> >> 12346.............AX8657.........04/10/2012.........30/11/2012.......4567.60 >> >> 12346.............AX7658.........07/10/2012.........30/11/2012.......3456.45 >> >> Should you need anything more please contact Subu at ......@yahoo.com or >> at +98354xyzab for further information >> >> Thanking you >> Yours Sincerely >> >> Subu >> ======================= end of 2nd dunning email r======================= >> >> Each e mail is to be sent to the respective customers e mail >> >> >> Thanks and regards >> Subu >> >> -- >> 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-...@googlegroups.com >> <javascript:>. >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> >> >> >> >> -- >> Regards, >> Anoop >> Sr. Developer >> -- >> 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-...@googlegroups.com >> <javascript:>. >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> 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-...@googlegroups.com >> <javascript:>. >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> >> >> >> >> -- >> Regards, >> Anoop >> Sr. Developer >> -- >> 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-...@googlegroups.com >> <javascript:>. >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >> >> >> >> >> > > > -- > Regards, > Anoop > Sr. Developer > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
