View Single Post
  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Phil00 Phil00 is offline
external usenet poster
 
Posts: 5
Default Formating changes using the macro to merge letters to separate

Hmm€¦the line of code that was given to me from Graham was on one line from
the start. I guess I do not fully understand this. Its getting to be rather
frustrating. I created a template and put it in the template folder and
directed the path in that code to grab that .dot file, didnt work. I then
directed that path to lead to a document used for the mail merge minus any
fields filled out or anything, it didnt work. Ive tried multiple
combinations. Of course Im sure its, just a minor detail being overlooked.
Is there a way I could forward or post the file somewhere to get a second
opinion straight from you guys, the mvps?

Thanks again.


"Doug Robbins - Word MVP" wrote:

If in the code, you have the command split across two rows, place the cursor
at the end of the first line and press delete, to get the command all on one
row.

Or, insert a Visual Basic line break character (space then underscore) as
follows

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Phil W" wrote in message
...

The exact error code is 4605 command not available.

Phil00;325336 Wrote:
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 -


-





--
Phil W