Dear experts,
I need to extend word to allows users to create documents. In the document, I added a new menu item and pops a window listing some fields where users can select and place in the document. The problem now is I don't know how to add fields using VBA. I checked many documents, all telling Ctrl-F9 or existing word dialogues the only way to insert fields.
I'm not sure if fields is the correct way to handle this. I am also considering mail merge and bookmarks but fail to find any good documents.
Could you please let me know what's the best way to achieve this.
Many thanks in advance.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
okay, you've got your fields listed on your new menu, right? And you want the macro to insert fields off of the menu, right? Yyou tell word to start recording a macro, and then you pick the fields you want off of the menu, then end the recording of the menu. Then when the user runs the macro (presses the button on the toolbar we've assigned, presses the hotkey we've assigned, however we decide to have the macro start), the macro will (should;) do what we did when we recorded it.
Problem with recording: you can't use mouse commands when recording, only keyboard commands. I don't think this would be a problem from what you've said so far though, should be able to select items from your menu with the keyboard alone.
Let me know if this would be what you're looking for, and if it is we'll work on the details
Dear JOrzech,
I'm still struggling here.
May be I haven't stated my requirement right.
What I need to do is to allow users to select some pre-defined fields from a list I'll provide. That is, when they're creating their document (i.e. letter etc), they'll insert those fields into the document. After the document is completed, I'll need to do a "mail-merge" (in quotes because I'm not sure if this is what I should do) replacing all fields with actual values.
Is fields the correct feature here or should I use something else? In either case, how to achieve what I wanted to?
Many thanks.
Yes - you should be doing a mail merge using mergefields. Please see Dreamboat's article here:
http://www.theofficeexpert
The "values" should be contained in a data source file (which simply a Word table with columns for each field). Something like:
Name Address Salutation
SkyWalker 123 Main Street Mr. Skywalker
Anytown, NY 11111
I don't see a need to use VBA other than perhaps to generate your popup window displaying the fields....
This question has been classified as abandoned. I will make a recommendation to the moderators on its resolution in approximately one week. I would appreciate any comments by the experts that would help me in making a recommendation.
It is assumed that any participant not responding to this request is no longer interested in its final deposition.
If the asker does not know how to close the question, the options are here:
http://www.experts-exchang
Dreamboat
EE Page Editor - MS Office Technology Channel
Business Accounts
Answer for Membership
by: gilbarPosted on 2003-10-15 at 07:01:15ID: 9554762
Simple Answer; record a Macro.