> > Hello Team, > > I am using macro for mail merge and wanna know how to make changes in font > type and how to bold a particular line/word while doing mail merge > > Thanks and Regards > Atul Kesaria >
> On Wed, May 12, 2010 at 11:18 PM, Harpreet Singh Gujral < > harpreetguj...@gmail.com> wrote: > >> FYI >> >> ---------- Forwarded message ---------- >> From: Harpreet Singh Gujral <harpreetguj...@gmail.com> >> Date: Wed, May 12, 2010 at 11:04 PM >> Subject: Re: $$Excel-Macros$$-Macro to Prepare Letters >> To: Atul Kesaria <atul.kesa...@gmail.com> >> >> >> Atul, >> >> I had a look at ur problem and researched over it. >> >> As per me, or my understanding of the information available on the >> internet, its better to open Word and use Mail merge feature. >> You can read some stuff on the following: >> http://www.ozgrid.com/forum/showthread.php?t=30692 >> >> But, there could be a solution to it......If i leave mail merge feature on >> the side >> >> While writing this email it came to my mind, why dont we bring the letter >> format to Excel. See Sheet2 in the attached workbook >> >> If the idea looks reasonable, i can create a look to go through all the >> records in Sheet1 [One by one], it will paste the data in Sheet 2 and print >> a letter. This was you can print all your letters at a click of a button >> >> Let me know, if you think this is a good idea >> >> Harry >> >> >> >> On Wed, May 12, 2010 at 4:21 PM, Atul Kesaria <atul.kesa...@gmail.com>wrote: >> >>> Hello Harry, >>> >>> You can use the same file which i have send u earlier as the actual data >>> and the letter format preparation is under process. >>> >>> I would try to modify your macro to my need and of course need-less to >>> say would take your help if I am not able to do it myself. >>> >>> Thanks and Regards >>> Atul Kesaria >>> >>> On Wed, May 12, 2010 at 3:02 PM, Harpreet Gujral < >>> harpreetguj...@gmail.com> wrote: >>> >>>> Yeah, got your point >>>> >>>> This means, you have a single formatted letter with fields from the >>>> excel sheet. You want letters to be generated for all the records in excel. >>>> >>>> Can you send the letter and a sample data, 4-5 records would do. >>>> >>>> I would have a look at it >>>> >>>> >>>> Harry >>>> >>>> Sent on my BlackBerry® from Vodafone Essar >>>> ------------------------------ >>>> *From: *Atul Kesaria <atul.kesa...@gmail.com> >>>> *Date: *Wed, 12 May 2010 14:40:41 +0530 >>>> *To: *<harpreetguj...@gmail.com> >>>> *Subject: *Re: $$Excel-Macros$$-Macro to Prepare Letters >>>> >>>> Hello Harry, >>>> >>>> The excel sheet is just a format, my file include other heads instead of >>>> address, it would include salary numbers, department name, employee ID etc >>>> >>>> Basically I am looking at capturing all the field of that particular row >>>> in one letter at the predefined place. So one letter for each row item. >>>> >>>> I hope I am able to clear your doubt. >>>> >>>> Thanks and Regards >>>> Atul Kesaria >>>> >>>> On Wed, May 12, 2010 at 9:55 AM, Harpreet Gujral < >>>> harpreetguj...@gmail.com> wrote: >>>> >>>>> I had a quick look on what you want to do. >>>>> >>>>> Of what I understand is, you pick up addresses from the excel sheet and >>>>> you want to use a word doc as a format. >>>>> >>>>> There could be two things: >>>>> 1) You want to print a single letter for the whole list in the excel or >>>>> >>>>> 2) You want to use a letter format depending upon a criteria. Eg: if >>>>> 2nd row on excel does not meet a criteria then use 2nd format of the >>>>> letter >>>>> >>>>> I hope I am able to make clear my doubt >>>>> >>>>> If you can provide some clarification on the above two points, then may >>>>> be I am able to help you out >>>>> >>>>> Harry >>>>> >>>>> Sent on my BlackBerry® from Vodafone Essar >>>>> ------------------------------ >>>>> *From: *Atul Kesaria <atul.kesa...@gmail.com> >>>>> *Date: *Wed, 12 May 2010 09:05:55 +0530 >>>>> *To: *Harpreet Singh Gujral<harpreetguj...@gmail.com> >>>>> *Subject: *Re: $$Excel-Macros$$-Macro to Prepare Letters >>>>> >>>>> Hello Harry, >>>>> >>>>> I mean i can use different macro for preparing different format of >>>>> letters. It is not necessary that macro should pick up a particular format >>>>> of letter and then print it. >>>>> >>>>> Are you going built the format within the macro or you would link to >>>>> predefine letter format. I have got one macro but it does not work. >>>>> Attached >>>>> is the macro in text file and the excel sheet which need to saved on c >>>>> drive >>>>> so that macro picks up the data from the said path. >>>>> >>>>> Thanks and Regards >>>>> Atul Kesaria >>>>> >>>>> On Wed, May 12, 2010 at 7:24 AM, Harpreet Singh Gujral < >>>>> harpreetguj...@gmail.com> wrote: >>>>> >>>>>> 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 >> > > -- ---------------------------------------------------------------------------------- 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
