How Can I mail merge a customer name and bought product list? RobertoB 11/19/2008 3:55:02 PM Hi, I have a Database that has the following: CUST - DATE - PRODUCT - PRICE 111 200810 PENS 1.50 111 200809 PENS 1.50 111 200807 BOOKS 10.00 115 200810 PENS 1.50 116 200809 BOOKS 10.00 And I want to create a mail letter to each one of my customers with a list of the products they have bought so far, including the price of it: So the letter will look like: Dear Customer 111 You bought the following: 200810 PENS 1.50 200809 PENS 1.50 200807 BOOKS 10.00 Thank you for your custom. etc. Next letter should be: Dear Customer 115 You bought the following: 200810 PENS 1.50 Thank you for your custom. etc. So Can I do that with Word Mail Merge??? Thank you for your help.

Re: How Can I mail merge a customer name and bought product list? "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/19/2008 7:41:41 PM To see how to do this, take a look at: http://cornell.veplan.net/article.aspx?&a=3815 or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at: http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "RobertoB" <RobertoB[ at ]discussions.microsoft.com> wrote in message news:004985C0-8704-4FB3-BA0A-5E2AE3F91868[ at ]microsoft.com... [Quoted Text] > Hi, I have a Database that has the following: > > CUST - DATE - PRODUCT - PRICE > 111 200810 PENS 1.50 > 111 200809 PENS 1.50 > 111 200807 BOOKS 10.00 > 115 200810 PENS 1.50 > 116 200809 BOOKS 10.00 > > And I want to create a mail letter to each one of my customers with a list > of the products they have bought so far, including the price of it: > > So the letter will look like: > > Dear Customer 111 > > You bought the following: > > 200810 PENS 1.50 > 200809 PENS 1.50 > 200807 BOOKS 10.00 > > Thank you for your custom. > > etc. > > Next letter should be: > > Dear Customer 115 > > You bought the following: > > 200810 PENS 1.50 > > Thank you for your custom. > > etc. > > So Can I do that with Word Mail Merge??? > > Thank you for your help.

Re: How Can I mail merge a customer name and bought product list? RobertoB 11/19/2008 10:52:00 PM Thank you very much. "Doug Robbins - Word MVP" wrote: [Quoted Text] > To see how to do this, take a look at: > http://cornell.veplan.net/article.aspx?&a=3815 > > or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at: > > http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107 > > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "RobertoB" <RobertoB[ at ]discussions.microsoft.com> wrote in message > news:004985C0-8704-4FB3-BA0A-5E2AE3F91868[ at ]microsoft.com... > > Hi, I have a Database that has the following: > > > > CUST - DATE - PRODUCT - PRICE > > 111 200810 PENS 1.50 > > 111 200809 PENS 1.50 > > 111 200807 BOOKS 10.00 > > 115 200810 PENS 1.50 > > 116 200809 BOOKS 10.00 > > > > And I want to create a mail letter to each one of my customers with a list > > of the products they have bought so far, including the price of it: > > > > So the letter will look like: > > > > Dear Customer 111 > > > > You bought the following: > > > > 200810 PENS 1.50 > > 200809 PENS 1.50 > > 200807 BOOKS 10.00 > > > > Thank you for your custom. > > > > etc. > > > > Next letter should be: > > > > Dear Customer 115 > > > > You bought the following: > > > > 200810 PENS 1.50 > > > > Thank you for your custom. > > > > etc. > > > > So Can I do that with Word Mail Merge??? > > > > Thank you for your help. > > >