Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How come Word is adding zeros to a mail merge number from Excel? | Excel Worksheet Functions | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Excel rounds up, then in mail merge uses nonrounded data | Excel Discussion (Misc queries) | |||
How do I attach an excel document to a word one for mail merge? | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) |