Automate MS Office document writer and use a text form field in the file name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rligouri@allwaysforwarding.com - 07 Apr 2006 21:22 GMT

I have a bunch word forms that need to be converted to tif for an
imaging system. I am very new at vba and i need some help. I want to
create a macro to print the document to Microsoft Office Document Image
writer and save the file to a specified folder (using vba) and name the
file based on a text form field. So far I have:

ActivePrinter = "Microsoft Office Document Image Writer"
Application.PrintOut FileName:="", Range:=wdPrintAllDocument,
Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="",
PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True,
PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0,
PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0

It gets me up to the the file save as screen.

Any Ideas? Any help would be greatly appreciated.

Reply to this Message

Doug Robbins - Word MVP - 09 Apr 2006 18:58 GMT

Application.PrintOut
FileName:=ActiveDocument.FormFields("formfieldbookmarkname").Result

Signature

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

>I have a bunch word forms that need to be converted to tif for an
> imaging system. I am very new at vba and i need some help. I want to
[quoted text clipped - 16 lines]
>
> Any Ideas? Any help would be greatly appreciated.

Reply to this Message