Reply
 
Thread Tools Display Modes
  #1   Report Post  
Fred via OfficeKB.com
 
Posts: n/a
Default trouble importing excel files into the word mailmerge

I have Windows XP and MS Office 2000 Premium. I have completed the mail merge
before, but was from a spreadsheet that someone else had sent to me. When
trying to import the data it says that it can't be imported due to improper
format. What format does it have to be in? Probably a stupid question, but
not getting it...
  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default trouble importing excel files into the word mailmerge

See the article "Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMe...DataSource.htm


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

"Fred via OfficeKB.com" u15479@uwe wrote in message
news:56de2672cf67a@uwe...
I have Windows XP and MS Office 2000 Premium. I have completed the mail
merge
before, but was from a spreadsheet that someone else had sent to me. When
trying to import the data it says that it can't be imported due to
improper
format. What format does it have to be in? Probably a stupid question, but
not getting it...



  #3   Report Post  
Fred via OfficeKB.com
 
Posts: n/a
Default trouble importing excel files into the word mailmerge

I read the selection that you provided, but it does not go into the format
that you must save the file in excel in for it to be accessible to word. My
problem is not how to set up the new document. It is that once it has been
properly set up that it won't be imported into Word "due to improper format".
It suggests downloading the new file from the original set up disc, but
wouldn't pull the file it needed out.

Doug Robbins - Word MVP wrote:
See the article "Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMe...DataSource.htm

I have Windows XP and MS Office 2000 Premium. I have completed the mail
merge

[quoted text clipped - 3 lines]
format. What format does it have to be in? Probably a stupid question, but
not getting it...



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200511/1
  #4   Report Post  
Myrna
 
Posts: n/a
Default trouble importing excel files into the word mailmerge

HI - I'm not an MVP....but I've done a lot of mail merges with Excel as the
file containing my data. I save the Excel file as .xls. When I get to the
step where I specify the input file, I browse to the file and select it. I
don't use the Import capability at all.

Myrna


"Fred via OfficeKB.com" wrote:

I read the selection that you provided, but it does not go into the format
that you must save the file in excel in for it to be accessible to word. My
problem is not how to set up the new document. It is that once it has been
properly set up that it won't be imported into Word "due to improper format".
It suggests downloading the new file from the original set up disc, but
wouldn't pull the file it needed out.

Doug Robbins - Word MVP wrote:
See the article "Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMe...DataSource.htm

I have Windows XP and MS Office 2000 Premium. I have completed the mail
merge

[quoted text clipped - 3 lines]
format. What format does it have to be in? Probably a stupid question, but
not getting it...



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200511/1

  #5   Report Post  
Fred via OfficeKB.com
 
Posts: n/a
Default trouble importing excel files into the word mailmerge

Thanks for the information, Myrna. I am afraid that it is a program file that
I was missing when the original MS Office was installed. I think that I have
bigger problems, since my disc drives are not responding either. I am moving
on. Thanks for all your help.

Myrna wrote:
HI - I'm not an MVP....but I've done a lot of mail merges with Excel as the
file containing my data. I save the Excel file as .xls. When I get to the
step where I specify the input file, I browse to the file and select it. I
don't use the Import capability at all.

Myrna

I read the selection that you provided, but it does not go into the format
that you must save the file in excel in for it to be accessible to word. My

[quoted text clipped - 12 lines]
format. What format does it have to be in? Probably a stupid question, but
not getting it...


--
Message posted via http://www.officekb.com
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
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Underscore (_) will not always display in RTF files (Word 2002). David A Edge Microsoft Word Help 6 June 14th 05 10:39 AM
is word perfect compatible with office word? Noreen Microsoft Word Help 1 May 11th 05 11:17 PM
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
In Word, how can I see all files (*.*) in "save as"? citizen53 New Users 8 April 4th 05 04:56 PM


All times are GMT +1. The time now is 10:11 AM.

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

About Us

"It's about Microsoft Word"