PC Review


Reply
Thread Tools Rate Thread

Automating open, save and print in Word, through Access use VBA

 
 
Lost without a button
Guest
Posts: n/a
 
      13th Feb 2009
Okay, I have been trying to find a solution to my problem. I want to create
a button in Access that will open a Word .doc, will mail merge data from my
database into a large range of fields in Word .doc and then both print and
save the file. All with the click of a button. The file needs to save as
a specific file name using a couple of pieces of data from Access and the
document needs to print using specific setting on my printer (i.e. Printing
on both sides of the paper). Any ideas or solutions to this. Any tips
maybe on good coding sites.
 
Reply With Quote
 
 
 
 
Alex Dybenko
Guest
Posts: n/a
 
      13th Feb 2009
hi,
check Super Easy Word Merge:
http://www.members.shaw.ca/AlbertKal.../msaccess.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"Lost without a button" <Lost without a (E-Mail Removed)>
wrote in message news:823560EC-6245-4DCB-9385-(E-Mail Removed)...
> Okay, I have been trying to find a solution to my problem. I want to
> create
> a button in Access that will open a Word .doc, will mail merge data from
> my
> database into a large range of fields in Word .doc and then both print and
> save the file. All with the click of a button. The file needs to save
> as
> a specific file name using a couple of pieces of data from Access and the
> document needs to print using specific setting on my printer (i.e.
> Printing
> on both sides of the paper). Any ideas or solutions to this. Any tips
> maybe on good coding sites.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating MS-Access DB to open correctly =?Utf-8?B?WFA=?= Microsoft Excel Programming 1 19th Mar 2007 03:37 PM
Automating MailMerge from Access - Word unable to open datasource =?Utf-8?B?RW1tYSBBdW1hY2s=?= Microsoft Access VBA Modules 0 28th Nov 2006 07:54 PM
Open word document in access, scroll through it and print it Toine Microsoft Access 1 30th Aug 2006 11:16 AM
Word 2003 will not open folders to access or save files =?Utf-8?B?dGs=?= Microsoft Word Document Management 7 13th May 2006 06:11 PM
Automating Word - Print one page not entire document! =?Utf-8?B?cXVhcnR6?= Microsoft Excel Programming 1 25th Jan 2005 06:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:39 PM.