Re: Excel merge to Word Footer displays merge field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Cindy M -WordMVP- (C.Meister-C_at_hispeed.ch)
Date: 05/26/04


Date: Wed, 26 May 2004 17:26:42 +0200


> That was our initial thought as well, but it has nothing
> to do with the field codes -- those are separate items
> all together.
>
> I am referring to the merge fields that actual hold the
> place for the data in the footer.
>
OK, I'm confused :-) merge fields ARE field codes...

Since this is an automated thing, it's a bit difficult to be
sure exactly what you've got, and how it's getting there.
Are you saying
    - there are merge fields in the footer
    - the merge is executing (to a new doc? if not, can you
get it to do that so that you can see the structures?)
    - in the merge result, one sees the names of the fields
where the merge fields used to be, but no data?

The scenario this brings to mind is that the main merge
document type is catalog/directory instead of form letter,
envelope or label. Which version of Word is involved?

> >
> >> Using VB we have an excel program which merges it's
> data
> >> into a pre-formatted word template. This has worked
> great
> >> for some time, but I have one user that has a problem
> >> with the footer of his word document.
> >>
> >> It displays his name, address, etc. perfectly where
> the
> >> placeholders say it should, but the actual names of
> the
> >> merge fields is displayed on his screen and prints out
> on
> >> the report.
> >>
> >If your code doesn't specifically control this, the
> >application settings will have this effect. Display of
> field
> >codes is application- and not document-centric.
> >
> >The user should go to Tools/options/view and turn
> off "field
> >codes". Then to Tools/Options/Print and do the same.
> >

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)



Relevant Pages

  • Re: Page numbering in footer (if 2 pages)
    ... it did work for me but not for the poster. ... This message is posted to a newsgroup. ... > "Insert Number of Pages" buttons on the Header and Footer toolbar). ... >>> Close the header/footer. ...
    (microsoft.public.word.numbering)
  • Re: Page Numbering
    ... See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! ... This message is posted to a newsgroup. ... footer, click format page number>page number>start at 1. ... I have a large word document and I wish to restart the ...
    (microsoft.public.word.newusers)
  • Re: How do you Lock text to a page in word
    ... You can put material for a last page in your footer and have ... Word New User FAQ & Web Directory: http://addbalance.com/word ... Microsoft's Legal Users' Guide) http://addbalance.com/usersguide ... This message is posted to a newsgroup. ...
    (microsoft.public.word.newusers)
  • Re: Header / footer "insert autotext" not working
    ... please post all follow-ups to the newsgroup so ... > already containing footer autotext entries. ... >>Word New User FAQ & Web Directory: ... >>Microsoft's Legal Users' Guide) ...
    (microsoft.public.word.application.errors)
  • Re: Header & Footers
    ... Word MVP FAQ site: http://word.mvps.org ... please post all follow-ups to the newsgroup so ... >> header or footer. ... Please post replies ...
    (microsoft.public.word.docmanagement)