View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary L Brown Gary L Brown is offline
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?