Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 74
Default How do I prepare my Excel file for Word mail merge?

I have exported my customer list from Peachtree and opened the .csv file into
Excel. What do I do to the file now to make it's contents flow into my
letters in Word mail merge?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 219
Default How do I prepare my Excel file for Word mail merge?

Assumptions:
1) Your data is in consistant columns, ie. looks like a database
2) Assume your columns have individual headings

Actions:
1) If your data does NOT have headings, insert a row in Row 1 and put them in
2) Save the .csv as an Excel (.xls) file
3) Close the Excel file
4) Open Word
5) Go to 'Help' and enter 'Mail Merge'
6) Follow the help suggestions.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Anne" wrote:

I have exported my customer list from Peachtree and opened the .csv file into
Excel. What do I do to the file now to make it's contents flow into my
letters in Word mail merge?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default How do I prepare my Excel file for Word mail merge?

Look at these
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

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

http://www.mvps.org/word/FAQs/MailMe...ateADataSource.

In Excel you will need to gives column names/headers/labels to each field
(FNAME for First Name, LNAME for Last name, etc) and you need to tell Word
about these names. For example, I have a field called PROV (Canadian) while
Word wants STATE so in the address fields I have to tell Word that the
last-but-one item is PROVE and the last item is PCODE not ZIP.
Best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Anne" wrote in message
...
I have exported my customer list from Peachtree and opened the .csv file
into
Excel. What do I do to the file now to make it's contents flow into my
letters in Word mail merge?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How come Word is adding zeros to a mail merge number from Excel? Randy Toch Excel Worksheet Functions 1 May 24th 06 05:50 AM
Excel Outlook Attachments opening after several errors everytime cito_support Setting up and Configuration of Excel 2 March 13th 06 06:15 PM
Excel rounds up, then in mail merge uses nonrounded data Tboz Excel Discussion (Misc queries) 0 January 30th 06 06:22 PM
How do I attach an excel document to a word one for mail merge? Ruth Excel Discussion (Misc queries) 1 January 6th 06 10:29 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"