Atul, So you mean, that you need to use different format of a letter, basis on some condition. Is that correct?
If the answer is yes, please provide a condition on how you want to select a particular letter and mail it Harry On May 11, 3:54 pm, Atul Kesaria <atul.kesa...@gmail.com> wrote: > Hello Team, > > Can some one please help me. > > Thanks and Regards > Atul Kesaria > > > > > > On Sun, May 9, 2010 at 6:20 PM, Atul Kesaria <atul.kesa...@gmail.com> wrote: > > Hello Andy, > > > I can use mail merge, but thats a manual process and I want to use > > different format for for preparing letters which might go above 1000+ > > letter. Thge problem using mail merge manually is that it again require > > formatting and whicd adds up to more time in preparing letters. > > > Looking forwad for the help. > > > Thanks and Regards > > Atul Kesaria > > > On 5/7/10, Aindril De <aind...@gmail.com> wrote: > > >> Hi atul, > > >> Why dont u use mail merge. > > >> Regards, > >> Andy > > >> On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria > >> <atul.kesa...@gmail.com>wrote: > > >>> Hello Team, > > >>> I am looking at a macro to write letter in word (a predefine letter > >>> format) with certain field to be picked from an excel-sheet source. > > >>> Request you to send me macro code. > > >>> Thanks and Regards > >>> Atul Kesaria > > >>> -- > > >>> ---------------------------------------------------------------------------------- > >>> Some important links for excel users: > >>> 1. Follow us on TWITTER for tips tricks and links : > >>>http://twitter.com/exceldailytip > >>> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >>> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >>> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >>> To post to this group, send email to excel-macros@googlegroups.com > > >>> <><><><><><><><><><><><><><><><><><><><><><> > >>> HELP US GROW !! > > >>> We reach over 6,800 subscribers worldwide and receive many nice notes > >>> about the learning and support from the group.Let friends and co-workers > >>> know they can subscribe to group at > >>>http://groups.google.com/group/excel-macros/subscribe > > >> -- > > >> ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >>http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >> To post to this group, send email to excel-macros@googlegroups.com > > >> <><><><><><><><><><><><><><><><><><><><><><> > >> HELP US GROW !! > > >> We reach over 6,800 subscribers worldwide and receive many nice notes > >> about the learning and support from the group.Let friends and co-workers > >> know they can subscribe to group at > >>http://groups.google.com/group/excel-macros/subscribe > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group > athttp://groups.google.com/group/excel-macros/subscribe- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe