Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
peterk peterk is offline
external usenet poster
 
Posts: 7
Default word 2007 mailmerge problem

I would value some help on mailmerge issues in Word 2007, which our office
has recently upgraded to.

We are a Christian aid organisation. One admin job is to send out regular
receipts to donors. We have several merge letters each linked to a text
file. We are used to Word 97 where the merge file is saved with the link,
and for each batch the text file is overwritten with newly exported data. So
the merged file can be created in 2 clicks - Open and Merge.

In Word 2007, we have worked out how to open and merge the letter, but it
takes much longer, because we don't know how to save the link to the data
file. This means every time we open the letter, we have to recreate all the
merge settings from scratch.

Is this correct, or are we missing something obvious?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default word 2007 mailmerge problem

See http://www.gmayor.com/merge_labels_with_word_2007.htm which covers the
merge process in Word 2007.
If you put the data file in the My Data Sources folder or in the same folder
as the merge document, the document should be able to find its data source
next time.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



peterk wrote:
I would value some help on mailmerge issues in Word 2007, which our
office has recently upgraded to.

We are a Christian aid organisation. One admin job is to send out
regular receipts to donors. We have several merge letters each
linked to a text file. We are used to Word 97 where the merge file
is saved with the link, and for each batch the text file is
overwritten with newly exported data. So the merged file can be
created in 2 clicks - Open and Merge.

In Word 2007, we have worked out how to open and merge the letter,
but it takes much longer, because we don't know how to save the link
to the data file. This means every time we open the letter, we have
to recreate all the merge settings from scratch.

Is this correct, or are we missing something obvious?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default word 2007 mailmerge problem

If you put the data file in the My Data Sources folder or in the same
folder
as the merge document, the document should be able to find its data

source
next time.


Some of this seems to depend on the type of data source, e.g. if the
data source is not where the document "thinks" it is,
a. if it's a .csv, Word will find it in My Data Sources or the same
folder as the document (all other things being equal)
b. if it's a .txt, Word will find it in the same folder as the
document (all other things being equal), but not in My Data Sources

(This is with Vista + Word 2007)

Although the difference in behaviour between (a) and (b) seems slightly
odd, that's nothing new when it comes to mailmerge. Perhaps more
predictable is that...

c. if it's (say) a .xlsx, Word won't find it in either place. In that
case Word may prompt with the OLE DB datalink dialog box before it has
even popped up its slightly more informative "can't find the data
source" dialog box. OK, so .xlsx is less likely in the case where a
program is exporting data form a database for merge. But if you happened
to have "Confirm file format conversion on open" switched on when you
connected to a .txt, and selected the OLE DB database option (typically
the only one on offer in Word 2007), you get the same problem.

If the mail merge main document and the data source are in the same
folder, but that's a network folder, I suspect a rather different set of
rules comes into play.

Peter Jamieson

http://tips.pjmsn.me.uk

On 18/11/2009 07:53, Graham Mayor wrote:
See http://www.gmayor.com/merge_labels_with_word_2007.htm which covers the
merge process in Word 2007.
If you put the data file in the My Data Sources folder or in the same folder
as the merge document, the document should be able to find its data source
next time.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with MailMerge in Office 2007 [email protected] Mailmerge 1 January 10th 09 09:07 AM
Word / Excel mailmerge problem Lucifa42 Mailmerge 4 February 6th 08 04:46 PM
Mailmerge Problem with Word in Office 2003 Ray S. Mailmerge 4 October 31st 07 12:56 AM
Problem with Mailmerge in Word 2003 Nicci Mailmerge 1 February 17th 06 05:46 AM
XML Word Mailmerge problem Enq Mailmerge 1 March 22nd 05 12:48 AM


All times are GMT +1. The time now is 12:07 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"