how merge csv file into document as table ?

R

Roman Rumisek

Hi,

i have two csv files - control file and data file.

Control file:

Corp_id;corp_name;corp_street;corp_city
100;"corporation";"Street name";"City"
.......
200;"corporation 1"; "Street name 1";"City 1"


and data file:

CustId;First_name;Last_name;Cust_street;Cust_City;Corp_id
1000;"Paul";"Sweet";"Cust street";"Cust City";100
....................
2000;"Jane";"Sweet";"Cust street 1";"Cust City 1";100
...............

I can merged this file in one letter to one corpartion as like this:

Hello,

Corp_name
Corp_street
Corp_city

blablabla
.......

+------+--------+------------+-----------+
|Paul |Sweet |Cust street |Cust City |
....................................................................
|Jane |Sweet |Cust street 1 |Cust City 1 |
+------+--------+------------+-----------+

Best regards,
..................

Any help would be appreciated.
Roman
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

Not simply with mailmerge.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top