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

Merge form data into word doc

P: 6
Hey all,

I'm hoping someone can help. I'm a bit of a novice when it comes to access, but what I'm hoping to achieve is to click a button on my form entitled contacts, which opens a word document (a letter) that automatically enters the details of the open record (forename, surname, address) on that letter. All I have achieved so far is to open word.

Is this possible? If so, how?!

Thanks in advance,

Col
Oct 27 '06 #1
Share this Question
Share on Google+
3 Replies


pks00
Expert 100+
P: 280
What u want is mailmerge

http://support.microsoft.com/kb/209976
http://support.microsoft.com/kb/214183
http://www.blueclaw-db.com/mailmerge_word_doc_access.htm
Oct 27 '06 #2

P: 6
col
Thanks PKS,

I am able to do a merge, but was wondering whether it was possible to do this directly by clicking a button on the form. It seems not!!

Thanks again,

Col
Oct 27 '06 #3

PEB
Expert 100+
P: 1,418
PEB
I think yeah,

But it's a hard work my God! Using Ole Automation!

If you are famillar with VB go in VB Access help and search
CreateObject
Ole automation

You need to know abaout also a bit of Word Basic :) ;) To accomplish it directly

I've never done it... Coz I use the reports in Access but the transfer for one record in Word is a good idea...

Take care my frien! With Word Basic you can automate the mail merge without opening Word - so see well the help from PKS :)

:)
Oct 27 '06 #4

Post your reply

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