PC Review

Thread Tools Rate Thread

Re: Problems merging an excel file due to code or file problems?

Cindy M -WordMVP-
Posts: n/a
      14th Sep 2004
Hi =?Utf-8?B?SmFzb24gTA==?=,

[Coming from the Word.mailmerge.fields group]

Which version of Word/OFfice are we dealing with, here?

What issue were you having with "text" fields, more exactly?

Is the data range in the Excel table on the first sheet? Does it start in cell
A1? Have you applied a range name to it? You probably should do the last, at
the very least.

> I posted an earlier question regarding formatting excel cells as text for
> importing purposes. That seems to be working okay, but now I have another
> problem. After this file has been saved, I need to merge it into a Word
> source. When I do this, I step through the merge wizard, and after I choose
> the Excel sheet and click OK, I get another strange window asking me to
> select a table. Thing is, there is no table to select. I have to click
> Cancel. If I try to click OK it say Word unable to open Merge Source. I
> don't know what I did or what happened. I've tried this several times by
> changing the cells formatted as text (errors were displayed cells because
> they were formatted as text) to General. Still didn't work. I am posting
> this on Word sites, because I don't receive this error until I try to merge
> with Word. I don't think it has much to do with Word, though. Here is my
> code. I am basically trying to figure out if there is something in my code
> that could have screwed up this process. It was working fine before I
> altered the code to format the first five cells as text.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)

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

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Field change color when a date is about to be due or is past due =?Utf-8?B?SmVzc2ljYQ==?= Microsoft Access VBA Modules 11 7th Jul 2005 09:54 PM
Past Due - Due Dates =?Utf-8?B?bWVsYXJtb3I=?= Microsoft Excel Worksheet Functions 3 2nd Jun 2005 06:13 AM
Otlk Today's screen should display due date Tasks BEFORE due date. =?Utf-8?B?bXdpbGc=?= Microsoft Outlook Discussion 0 18th Apr 2005 06:19 PM
How do I get my reminder window to show the due date for the "Due. =?Utf-8?B?bW9vbmdkZXM=?= Microsoft Outlook Discussion 1 31st Jan 2005 03:39 PM
Any way to get Tasks with Due Dates to show up in the Calendar on the Due Date? Scott Townsend Microsoft Outlook Calendar 5 21st Jan 2004 12:20 AM




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