View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merge data disappearing when printing

Somewhere on that page there is a New button that you should use.

The experience that you are having is caused by the option being set under
ToolsOptionsPrint to Update the fields. Turn that off (which I would not
recommend) and the unconventional way in which you are operating will
probably be OK.

You should however see the "Individual Merge Letters" item on fellow MVP
Graham Mayor's website at:
http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.


--
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

"sarahm" wrote in message
news
Please excuse the butt-in - my page doesn't appear to let me start a New
thread and this is the only way I could see to get my question on there.

I am merging from an Excel spreadsheet. The data merges fine and is on
screen. I usually copy that page to a new page so it is no longer
attached
to the data source, saving the new, unconnected page. [I have used this
method for some time and always retained the data fine]

Now, when you go back into that document (that is no longer attached to
the
data source), the data is there, but as soon as you print it, it switches
to
merge prompts on screen and also prints out with merge prompts and not the
data.

I have trialled connecting via DDE and also OLE DB and still get the same
problem. The only other change is that we now have all data on a server
and
no longer on my computer.

Any help would be appreciated!
--
sarahm


"Doug Robbins - Word MVP" wrote:

From the Tools menu, select Options and then on the General tab, click on
Web Options and then select the Files tab and uncheck the option to
Update
links on save.

--
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

wrote in message
oups.com...
Hi,
I'm trying to fix a mailmerge INCLUDEPICTURE problem.

My data source contains the filename (eg "bhc.gif") and all files are
in a folder on our server ("P:\Events\Company logos for booklets").

I can create a merge field which can merge to a new document just
fine. However, once I save the source document, the merge field
changes!

For example, I start off with:
{ INCLUDEPICTURE "{ DOCVARIABLE "MyPath" }{MERGEFIELD
"ProductPhotoReceived" }" }

I merge to a new document, update the links and hey, presto - images
are all fine.

I go back to the source document, click save, and the merge field
changes to:
{ INCLUDEPICTURE "../../../Events/Company%20logos%20for%20booklets/
Holloway%20White%20Allom.jpg" \* MERGEFORMAT }

This effectively breaks the mergefield, and creating a new merge
document doesn't merge correctly.

Why is Word changing my fields?

Thanks in advance
Andy