View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Charles Kenyon
 
Posts: n/a
Default Macros and AutoTextLists in Mail Merge Document

Look into Userforms. You can create one that will pop up when the new
document is being created, get the information you need, put it in the right
place, and then allow a merge.
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"Caroline" wrote in message
...
Sorry if this is in the wrong section.

I'm trying to set out about 70 standard letters for my team at work, the
information being merged out from a CSV files created by our data
processing
programme. As part of this I need to additionally put in some
AutoTestLists.
After a scary amount of battling and constantly looking back to The Word
MVP
Site, I've managed to set this up, and make the files so I could
distribute
them to the rest of the team.

Sadly, some of the team don't have good IT skills and find remembering to
right click over the AutoTextLists *before* the merge the documents a
little
hard because they don't really understand how it works. Ideally what I
would
like to do is create a Macro that runs on opening that goes between each
AutoTextList and prompts the user to select the right entry, then merges
the
document to a new file. Unfortunately this is a little more complex then I
can think my way round.

If I don't use macros. Is there any other way round this? And if I do use
macros, any suggestions as to how to do this or where else to look for
information.

Any help would be greatly received. I'm about ready to rip my hair out!