Bypass having to choose a field in mail merge

[Dorak]

Why do you have to choose a field to search in when performing a mail merge.
My users are complaining that it's a hassle to push that extra button.

Is there a way to bypass that by setting the field to search on
programmatically so they enter initials and then hit return and the merge to
bookmarks is performed using the default "look in all fields"?

As it stands now, if they enter initials and hit return, it's only returning
the first record.
They have to choose "look in this field"... in order for the merge to work.

Is it not possible to programmatically change the default so it will look in
a particular field?

 

[Doug Robbins - Word MVP]

It sounds like you are just wanting to create one document from the
datasource in which case, mail merge may not be the best method.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

and the following pages of fellow MVP Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[CJ]

I am running into a total brick wall here. All I want to do is populate 4
bookmarks in a writer's block on a letterhead template. I want to have the
user enter their initials and then, using those initials, populate the
bookmarks appropriately from an excel spreadsheet.

This works nicely with mailmerge, even if it's not the best way to do it.
Users don't like having to click the "find in this field" button, they would
rather be able to just key in their initials and hit enter and be done with
it.

I am studying what you suggested, but I'm getting nowhere with getting my
information out of excel and into the bookmarks on the template. While I can
create a userform and populate bookmarks from what the user enters into a
textbox, I seem to be not grasping some key logic with respect to how to get
the correct information from my excel worksheet.

I'll keep trying......I feel so stupid.

 

[CJ]

I FOUND IT I FOUND IT I FOUND IT.....
"SELECT * FROM `AllPersonnel$` ORDER BY `Initials` ASC "

Ha, only took two years ...