Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
denuts denuts is offline
external usenet poster
 
Posts: 1
Default How do I set up an excel file to be used in a mail merge?

I entered the data into an excell file for addresses. I started by putting
labels in row one, then I put the addresses in row by row. I did not do
anything to the first row besides put in the labels. When I run mail merge in
word the program does not see any data or it gives an error that resources
are exceeded. Do I need to format the data base in a certain way to allow
mail merge to use it? Any step by step advice would be greatly appreciated?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sunday88310 Sunday88310 is offline
external usenet poster
 
Posts: 15
Default How do I set up an excel file to be used in a mail merge?

Mr D.
I just created a excel file using the extension (xls.) Did you check in the
mail merge porgram selection (xls.) It may be looking in the wrong location
and you must tell the mail merge to open the xls. files, then locate your
document and import it. The Mail merge will delimite the file for you. Have
fun....
From Mr. B


"denuts" wrote:

I entered the data into an excell file for addresses. I started by putting
labels in row one, then I put the addresses in row by row. I did not do
anything to the first row besides put in the labels. When I run mail merge in
word the program does not see any data or it gives an error that resources
are exceeded. Do I need to format the data base in a certain way to allow
mail merge to use it? Any step by step advice would be greatly appreciated?

  #3   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 How do I set up an excel file to be used in a mail merge?

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

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

See the article "How to convert addresses into a Mail Merge Data Source" at:

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

See the article "How to create a Mail Merge" at:

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

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_lab...th_word_xp.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

"denuts" wrote in message
...
I entered the data into an excell file for addresses. I started by putting
labels in row one, then I put the addresses in row by row. I did not do
anything to the first row besides put in the labels. When I run mail merge
in
word the program does not see any data or it gives an error that resources
are exceeded. Do I need to format the data base in a certain way to allow
mail merge to use it? Any step by step advice would be greatly
appreciated?



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 do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
Mail merge directory using excel file donna Mailmerge 10 February 16th 06 05:13 AM
EXCEL file as a database for Word mail merge in XP. how do I do it Nana Scherr Mailmerge 2 February 9th 06 07:19 AM
Using HTML file as data source for Mail Merge thenin Mailmerge 4 November 21st 05 08:03 AM
Attaching different Excel files to emailed mail merge using merge. Pete Cuff Mailmerge 1 November 3rd 05 06:54 PM


All times are GMT +1. The time now is 10:46 PM.

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"