Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-15 Thread Azhar Rai
Thanks Alvin My question is HOW? I am just failed to accomplish the task. Please help me. AZHAR RAI Skype: azhar.rai On Wed, Jun 16, 2010 at 07:10, fongie wrote: > Hi Azhar, > > Try using a variable for your file name. This variable file name can > be driven from the mail merge data set or f

Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-15 Thread fongie
Hi Azhar, Try using a variable for your file name. This variable file name can be driven from the mail merge data set or from an adjacent data set. Alvin On Jun 15, 8:08 pm, Azhar Rai wrote: > Hi All > > Finally I have recorded the following macro code: > > Sub reports() > ' > ' reports Mac

Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-15 Thread Azhar Rai
Hi All Finally I have recorded the following macro code: Sub reports() ' ' reports Macro ' ' With ActiveDocument.MailMerge .Destination = wdSendToNewDocument .SuppressBlankLines = True With .DataSource .FirstRecord = ActiveDocument.MailMerge.DataSource.Act

Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-04 Thread Azhar Rai
Hello Gurus I am afraid I did not receive response from anyone. AZHAR RAI Cell: +92-333-552-7731 Skype: azhar.rai On Thu, Jun 3, 2010 at 10:03, Azhar Rai wrote: > Hi Gurus > > My work relates to prepare a large number of reports and I use mail merge > for all this process. I have to save each

$$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-02 Thread Azhar Rai
Hi Gurus My work relates to prepare a large number of reports and I use mail merge for all this process. I have to save each and every report separately. The file name I need to use is also generated through mail merge at the very first line of each report in MS Word document. What I need is when