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 / October 2007

Tip: Looking for answers? Try searching our database.

Inserting Autotext during a merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ricki Miles - 26 Oct 2007 21:27 GMT
I am upgrading a mail merge template into Word XP that was previously used
in Word 2 (yes, Word 2!!!!) with data coming from a mainframe.  There are
over 50 signatures (just regular text formatted with a script font) that
were used in Word 2 as glossaries.

As an example, if the signature for Mary Smith was created as a glossary
"ms", and "ms" would be entered in the data header for the signatures was
"sig", the mergefield in the template was

{glossary {mergefield sig} }

When merged, the glossary "ms" would be placed in the document and would
automatically expand to "Mary Smith".

I have been unsuccessful getting AutoText in Word XP to automatically expand
when merged.  I do not want to use macros unless there is no way around
them.

I appreciate any suggestions - TIA,

Ricki
Peter Jamieson - 27 Oct 2007 12:59 GMT
If you add a bit more nesting and use

{ AUTOTEXT "{ IF 1 = 1 "{ MERGEFIELD sig }" }" }

you should be OK. Incidentally, you can still use

{ GLOSSARY "{ IF 1 = 1 "{ MERGEFIELD sig }" }" }

in Word XP but I suepect now would be a good time to change :-)

Peter Jamieson
>I am upgrading a mail merge template into Word XP that was previously used
>in Word 2 (yes, Word 2!!!!) with data coming from a mainframe.  There are
[quoted text clipped - 17 lines]
>
> Ricki
Ricki Miles - 27 Oct 2007 17:57 GMT
Hi Peter,

Thank you so much for the response.

I have tried the syntax you sent, but I am not getting the autotext to fill
in when I complete the merge.

Here is what I have done:
Create an autotext in normal.dot called "rm" which will expand to give me a
signature of several lines
Create a Word document called 'data.doc" which contains a one column/two row
table, the first row is "sig" and the second row is "rm"
Create a mail merge letter using the data.doc source, type in the following
using Control+F9 for the braces:

{AUTOTEXT "{IF 1=1 "{MERGEFIELD sig}"}"}

When I merge, I get the following message "A field calculation error
occurred in record 1", I click OK, and then in the resulting document
"Error! AutoText entry not defined".

I have tried using the original GLOSSARY field, but it does not work either.

By the way, the "sig" field will always have an entry, so should there is
actually no need for an  IF statement, just the autotext entry in that field
needs to be expanded in each letter as a signature.

Can you tell me what I am doing wrong?  I really appreciate your help!!!

Ricki

> If you add a bit more nesting and use
>
[quoted text clipped - 28 lines]
>>
>> Ricki
Peter Jamieson - 27 Oct 2007 18:39 GMT
Were /all/ the special field code braces entered using ctrl-F9?

If so, if you set thing up so you are previewing the data, then display the
field codes (Alt-F9), select the { MERGEFIELD sig } field, right click and
select the toggle fields option, do you see "rm" ? If you then select the
entire { IF 1 = 1 field, right-click and select the toggle fields optin, do
you still see "rm"?

> By the way, the "sig" field will always have an entry, so should there is
> actually no need for an  IF statement, just the autotext entry in that
> field needs to be expanded in each letter as a signature.

I agree that that is how it probably should be, but since it doesn't behave
properly the IF is just a trick to try to get it to do so.

Peter Jamieson

> Hi Peter,
>
[quoted text clipped - 60 lines]
>>>
>>> Ricki
Ricki Miles - 27 Oct 2007 19:30 GMT
Hi again, Peter,

THANK YOU!!!!  I'm not sure why it didn't work first time, but I retyped
using Control + F9 (maybe I hadn't done that for each brace the first time),
and it worked very well.  I would never have figured it out without your
help - Thanks again,

Ricki

> Were /all/ the special field code braces entered using ctrl-F9?
>
[quoted text clipped - 77 lines]
>>>>
>>>> Ricki

Rate this thread:






 
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.