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

mail merge from access to word using combo boxes for parameters

P: 65
Currently I have some letters set up in Word which merge off of an Access database. A window pops up and asks for the parameters of the query to be entered in a text box. Is there any way that I can use a combo box instead? If I merge directly in Access using VBA will I be able to use combo boxes? I have read that using VBA in this manner may cause some security problems.

Thanks again for your time
Nov 30 '06 #1
Share this Question
Share on Google+
4 Replies


P: 65
No Microsoft Office Specialists out there?
Dec 4 '06 #2

NeoPa
Expert Mod 15k+
P: 31,474
It should be possible to do as you suggest, but I'm not clear from the question if you're doing it from Word or Access.
I know very little about Word automation of any sort.
How many experts that regularly visit the Access forum are also familiar with Word I don't know.
I do know that answers depend on the clarity of the question as well as finding an expert qualified to answer.
Dec 4 '06 #3

P: 65
I appologize for any ambiguity. The letter is typed in word and uses a DDE connection to the Access query. The parameters in the query (date range) are entered in a text box that pops up when the letter is run from word.

I would like to make the text box a drop-down combo box. I do not believe this is possible if the letter is written in Word.

I have been exploring the option of performing mail merges directly in Access using VBA and it appears that it may cause security problems requiring the registry to be edited on the computer running VBA.

again, my appologies if this is not the correct forum for this kind of question

thanks for your time
Dec 4 '06 #4

NeoPa
Expert Mod 15k+
P: 31,474
FreeSkier,

I'm sure it's the best forum we have for this sort of question.
The problem requires more than one skill-set though, which makes it less likely to find anyone who can help.
I can't help much as Word is my weakest area in Office automation.
Have you, however, considered coding it in both Access AND Word.
Within either, you should be able to open the other Application (As long as the relevant Reference is enabled) and code exactly as if within the other application. I did this a long while back between Access & Excel and it was great. Worked like a charm. However, I've not really had a requirement to use it since, and never in Word.
With VBA control over both applications, could you do what you need?

PS. Ignore my tone - sometimes I can seem snappy (everyone else's mistake - never mine ;) ).
I hope to evangelise the world into posting more clearly explained (easily understood) questions as that way everybody benefits.
Good luck with your question btw.
Dec 4 '06 #5

Post your reply

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