Go Back   Cyber Tech Help Support Forums > Software > Applications

Notices

Reply
 
Topic Tools
  #1  
Old January 30th, 2002, 07:06 PM
JustJay's Avatar
JustJay JustJay is offline
Senior Member
 
Join Date: Apr 2001
Location: Montréal, Québec, Canada
Age: 33
Posts: 161
Word XP to PDF

OK - this might be a tough one...but a challenge nonetheless....

The Situation...

I have a client for which I create a newsletter for each week, however this client consists of 14 individuals that each have a different name, email address, and phone number that has to be put on each newsletter. So in effect each newsletter is completely personalised for them. That's the easy part (mail merge..blah blah blah )

The Challenge....

The final product needs to be in PDF...sure no problem...where the problem lies..is here....

Is it possible....to have Word print to either PDF or Distiller but automatically do it each page into a separtate file....

At present I am doing this by clicking FILE PRINT (choosing Printer) CURRENT PAGE over and over and over again....(Oh yeah did I mention that each copy is done in Color and then Black and White....)

So it takes me almost as long (if not longer) to tranform to PDF than it does to just create the newsletter....

Clear as mud?? Any1 got any Ideas??

Thanks,
Reply With Quote
  #2  
Old January 31st, 2002, 07:58 AM
smurfy's Avatar
smurfy smurfy is offline
Cyber Tech Help Moderator
 
Join Date: Sep 2000
O/S: Linux
Location: Christchurch New Zealand
Posts: 7,564
Hmmm, not really other than trying a macro.

Use the Macro recorder and record one instance of printing current page to B&W PDF and colour PDF and then select next page and stop recorder.
Create a custom toolbar button and assign the macro to the button and select first page of newsletter, run the macro and (hopefully) at the end you'll be at the next page and ready to press one button again to repeat the process.
If it works, 14 button click will finish the output.
__________________
CTH Mod errata: Applications - Gaming - Linux - Windows NT/2000/2003 - Windows95 forums.
Search for your problem - we may have already answered it for someone else.
As Private Messages are not searchable, they should not be used for asking or answering help questions.
Remember that we are all here to learn so please post back and tell us if it's working (or not).
If we have helped you, please consider supporting Cyber Tech Help with a subscription.

OneAna.com
Reply With Quote
  #3  
Old February 7th, 2002, 02:43 AM
JustJay's Avatar
JustJay JustJay is offline
Senior Member
 
Join Date: Apr 2001
Location: Montréal, Québec, Canada
Age: 33
Posts: 161
Works great! Thanks for the suggestion! Now I just wish it would automatically name the files for me! I know I know...I am asking for too much!

Thanks again!
Reply With Quote
  #4  
Old February 7th, 2002, 03:01 AM
smurfy's Avatar
smurfy smurfy is offline
Cyber Tech Help Moderator
 
Join Date: Sep 2000
O/S: Linux
Location: Christchurch New Zealand
Posts: 7,564
Quote:
Now I just wish it would automatically name the files for me! I know I know...I am asking for too much!
Not at all, if you are saving to the same location each time... I'll test the syntax and method tonight if I have time and post back instructions (I don't do a lot of Word VBA so need to test 1st).
__________________
CTH Mod errata: Applications - Gaming - Linux - Windows NT/2000/2003 - Windows95 forums.
Search for your problem - we may have already answered it for someone else.
As Private Messages are not searchable, they should not be used for asking or answering help questions.
Remember that we are all here to learn so please post back and tell us if it's working (or not).
If we have helped you, please consider supporting Cyber Tech Help with a subscription.

OneAna.com
Reply With Quote
  #5  
Old February 8th, 2002, 12:27 AM
smurfy's Avatar
smurfy smurfy is offline
Cyber Tech Help Moderator
 
Join Date: Sep 2000
O/S: Linux
Location: Christchurch New Zealand
Posts: 7,564
OK dammit, I guess the success of this depends on how you export to PDF.

On mine (using old version of PDF export print driver thingy) I have PDF output as a print option and the macro recorder only records "print" and no further details of file name or path.

JustJay, can you copy and paste the VBA module that Word created into a reply here. To find it, open the document then Tools>Macro>Visual Basic Editor.

I'll then take a look and see if file name change is possible.

[ 07 February 2002: Message edited by: smurfy ]
__________________
CTH Mod errata: Applications - Gaming - Linux - Windows NT/2000/2003 - Windows95 forums.
Search for your problem - we may have already answered it for someone else.
As Private Messages are not searchable, they should not be used for asking or answering help questions.
Remember that we are all here to learn so please post back and tell us if it's working (or not).
If we have helped you, please consider supporting Cyber Tech Help with a subscription.

OneAna.com
Reply With Quote
  #6  
Old February 8th, 2002, 01:46 AM
JustJay's Avatar
JustJay JustJay is offline
Senior Member
 
Join Date: Apr 2001
Location: Montréal, Québec, Canada
Age: 33
Posts: 161
Is this what you were talking about???

Sub Macro4()
'
' Macro4 Macro
' Macro recorded 2/3/2002 by ME
'
ActivePrinter = "\\Server\HP DeskJet 810C"
ActivePrinter = "Acrobat PDFWriter"
Application.PrintOut FileName:="", Range:=wdPrintCurrentPage, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
End Sub
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2/3/2002 by ME
'
Selection.Find.ClearFormatting
With Selection.Find
.Text = ""
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Application.PrintOut FileName:="", Range:=wdPrintCurrentPage, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
End Sub

[ 07 February 2002: Message edited by: JustJay ]
Reply With Quote
  #7  
Old February 8th, 2002, 01:49 AM
JustJay's Avatar
JustJay JustJay is offline
Senior Member
 
Join Date: Apr 2001
Location: Montréal, Québec, Canada
Age: 33
Posts: 161
BTW - WordXP & Adobe 5.0 can either print to Acrobat PDFWriter or Acrobat Distiller....

Hope that sheds some light...

Oh yeah one thing...you can call me Jay (just Jay...)
Reply With Quote
Reply

Bookmarks

Topic Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:17 PM.

[ RSS ]