Re: Formating changes using the macro to merge letters to separate



Alright, so im new to this whole macro thing in word. This document is
created from a 2 page template. If I were to use this code

Set NewDoc = Documents.Add(Template:="D:\Word Templates
Path\TemplateName.dot", Visible:=False)

Would i change the path to correspond where the template is? I tryed that
and got an error code indicating an error within the script.

Thanks for your prompt response though!!!

I look like a hero working on this in my office! hahaha


"Graham Mayor" wrote:

The macro creates a new document for each record based on normal.dot. If
your merge document is based on some other template then there will be some
inevitable differences in formatting when you run the macro. You could edit
the code to base your merge documents on a *blank version* of your letter
template if you wish eg change the line

Set NewDoc = Documents.Add(Visible:=False)
to
Set NewDoc = Documents.Add(Template:="D:\Word Templates
Path\TemplateName.dot", Visible:=False)

or better still create your merge documents from normal.dot
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Phil00 wrote:
Hey,

I'm using the macro found on G Mayor's site to help me merge letters
to seperate files. I finally got everything working. When i dont
split the files everything runs perfect, but as soon as i use the
macro, split the files, i notice the formating becomes ruined. I now
have a combination of fonts in the document as well as what seem to
be random page and section breaks.

Any ideas?

Thanks.

Phil



.



Relevant Pages

  • Re: How to remove automatically some pages?
    ... Word MVP web site http://word.mvps.org ... separately without the extra character. ... I used the macro to the big MailMerge output file and it ...
    (microsoft.public.word.newusers)
  • Re: How do i insert sequential numbers into a Word document templa
    ... Word MVP web site http://word.mvps.org ... however with a small change the macro will change to ... module in my invoice template, ...
    (microsoft.public.word.docmanagement)
  • Re: Macro not working on other pcs
    ... Word MVP web site http://word.mvps.org ... template to delete a macro contained in that template. ...
    (microsoft.public.word.newusers)
  • Re: How to remove automatically some pages?
    ... Word MVP web site http://word.mvps.org ... pages using tha macro from you. ... separately without the extra character. ...
    (microsoft.public.word.newusers)
  • Re: How to remove automatically some pages?
    ... Please tell me where is your e-mail address on your web site. ... Word MVP web site http://word.mvps.org ... separately without the extra character. ... After the process of MailMerging I delete the "extra" pages using the macro from ...
    (microsoft.public.word.newusers)

Loading