By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Creating a word document from Access

atsukoarai86
P: 6
I'm getting better at VBA, but I'm still pretty new to it, so here's my question.

I've developed a database and application in MS Access 2003, and it functions very well over all, but my bosses have requested that I add a different functionality to it. See, the database tracks our independent contractors and their credentials which need to be renewed, and I have reports that show what contractors' credentials are expiring and when.

what they want from me is to make it so they can click a button and generate a template letter in MS Word to the contractor in question about their expiring credentials, populated with the person's name, address, etc. so they can print it out and fax or mail it to him/her.

I have absolutely no clue how to do that. I had the idea of just bypassing Word and making a report that could be populated by variables from another form but... I'm still pretty much in the dark here.

Anyone able to point me in the right direction?

Thanks in advance
Nov 13 '08 #1
Share this Question
Share on Google+
1 Reply


southoz
P: 24
Good ay , I did something like that a few years ago have a look at this thread and it should give you most of the answers you are looking for.

http://bytes.com/forum/thread559954-southoz.html

southoz
Nov 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.