Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Olaf Egeberg Olaf Egeberg is offline
external usenet poster
 
Posts: 1
Default Data Source Evaporates

In Microsoft Office 2007 Word Mailmerge, When I "Select recipients" and
browse to my data source (a file on Excel) the "Select Table"dialog box pops
up with"Sheet 1$" highlighted. Everything is fine up to this point. But then
I click OK...AND THAT'S THE END OF IT. I don't get to see my data to confirm
and "select all." I can't go any further. Nothing got read. Zip.

I've been working on this for two days. If ANYONE can give me some help with
this I'd sure appreciate it.
Thanks
Olaf
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Data Source Evaporates

1. As an experiment, can you create a completely new workbook with some
test data and try to connect to that?

2. If that works OK, it's almost certainly a problem with the Workbook -
either it has been corrupted in some way (in which case, if it's a
simple data-only workbook, you could consider exporting to .csv and
creating a new workbook from that .csv. Or...
- it has other stuff in it that the OLE DB provider does not like. For
example, using Excel outlining sometimes seems to cause problems. But if
that's the case, I'm not sure I can help.

3. If you are completely stuck, ou should at least be able to export
using .csv and use that as the data source for your merge.

Peter Jamieson

http://tips.pjmsn.me.uk

On 05/02/2010 20:16, Olaf Egeberg wrote:
In Microsoft Office 2007 Word Mailmerge, When I "Select recipients" and
browse to my data source (a file on Excel) the "Select Table"dialog box pops
up with"Sheet 1$" highlighted. Everything is fine up to this point. But then
I click OK...AND THAT'S THE END OF IT. I don't get to see my data to confirm
and "select all." I can't go any further. Nothing got read. Zip.

I've been working on this for two days. If ANYONE can give me some help with
this I'd sure appreciate it.
Thanks
Olaf

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
How to link a different Mailmerge header source and data source? Eleni_Malli Mailmerge 1 May 3rd 06 02:08 PM
How can I add data fields to a data source in Word Mail Merge? cd Mailmerge 2 November 7th 05 06:41 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM
Merged data that is present in data source is missing in merge mbd_newjersey Mailmerge 1 December 17th 04 10:52 AM


All times are GMT +1. The time now is 10:51 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"