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 <alvin.c.s.f...@gmail.com> 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 from an adjacent data set.
>
> Alvin
>
>
>
>
> On Jun 15, 8:08 pm, Azhar Rai <azhar....@gmail.com> wrote:
> > 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.ActiveRecord
> > .LastRecord =
> ActiveDocument.MailMerge.DataSource.ActiveRecord
> > End With
> > .Execute Pause:=False
> > End With
> > Selection.EndKey Unit:=wdLine, Extend:=wdExtend
> > Selection.Copy
> > ActiveDocument.SaveAs2 FileName:="PAK000366 - USA.docx", FileFormat:=
> _
> > wdFormatXMLDocument, LockComments:=False, Password:="",
> > AddToRecentFiles _
> > :=True, WritePassword:="", ReadOnlyRecommended:=False,
> > EmbedTrueTypeFonts _
> > :=False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
> > SaveAsAOCELetter:=False, CompatibilityMode:=11
> > Windows("Progress Reports 2010 10 JUN 10.dotm [Compatibility
> Mode]").
> > _
> > Activate
> > End Sub
> >
> > The problem i am facing is only that:
> >
> > every time the file is saved with the same name and not for what the copy
> > function is performed.
> >
> > Please help me debug the problem.
> >
> > Thanks in anticipation of quick response.
> >
> > AZHAR RAI
> > Skype: azhar.rai
> >
> >
> >
> > On Fri, Jun 4, 2010 at 16:52, Azhar Rai <azhar....@gmail.com> wrote:
> > > 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 <azhar....@gmail.com> 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 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 I apply the save as command on MS Word the new
> file
> > >> name is fetched from the first line of the report (a combination of
> Ref No,
> > >> Name, country or whatever).
> >
> > >> Please help me out in the issue.
> >
> > >> Thanks
> >
> > >> AZHAR RAI
> > >> Islamabad, Pakistan
> > >> +92-333-552-7731
> >
> > >> --
> >
> > >>
> ---------------------------------------------------------------------------
> -------
> > >> 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 7000 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 7000 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 7000 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
