Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2006

Tip: Looking for answers? Try searching our database.

Macros and AutoTextLists in Mail Merge Document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Caroline - 15 Mar 2006 15:15 GMT
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!
Charles Kenyon - 15 Mar 2006 16:21 GMT
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
Signature

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.

> Sorry if this is in the wrong section.
>
[quoted text clipped - 25 lines]
>
> Any help would be greatly received. I'm about ready to rip my hair out!
Caroline - 15 Mar 2006 17:01 GMT
Thank you. That's given me a lot to look at.
Charles Kenyon - 15 Mar 2006 17:41 GMT
I know that it will mean reworking what you are doing, but in the long run I
expect it will be much easier for your users. With a userform, they won't
need to look for and find the AutoTextList fields.
Signature

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.

> Thank you. That's given me a lot to look at.
Caroline - 20 Mar 2006 15:45 GMT
Thank you very much. I have tried this out and it works perfectly. I need to
play about a bit to get it doing exactly what I need, IE putting certain
specifically formatted paragraphs, but I’m sure I can manage it.

Is it possible to easily transfer a UserForm from one document to another.
Will the ‘templates organiser’ allow me to do it using the Macro Project
Items tab?

Thank you again. You have helped me out a lot.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.