Replace values in Notepad file from CSV/Excel

[GreenBox]

Hi All,

I need your help to develop a Macro which will help me to eradicate a continuous task...

I have output in CSV as below

CSV FILE

Business Name	Address 1	City	State	Zip	Phone
Tips & Toes Nail Salon	9430 W 191st	Mokena	Illinois	60448	(708) 478-7420
L A Nails	11322 Lincoln	Mokena	Illinois	60423	(815) 464-9445
Asia Nails	19610 La Grange	Mokena	Illinois	60448	(708) 478-8590
Nails Palace & Spa	19834 La Grange	Mokena	Illinois	60448	(708) 995-5529
Kal Nails Spa	10148 W 191st t	Mokena	Illinois	60448	(708) 478-6285
Perfect Nails	9500 W Lincoln	Frankfor	Illinois	60423	(815) 806-8789
Jen Nails	2063 E Laraway	Lenox	Illinois	60451	(815) 462-1059
Classy Nails	15784 S LaGrange	Orland	Illinois	60462	(708) 226-1212
Best One Massage	16902 Oak Park	Tinley	Illinois	60477	(708) 532-3103
Magnificent Nails	19133 Wolf Rd	Mokena	Illinois	60448	(708) 478-7210

<tbody>
</tbody>

I need the above data to be replaced (TEXT File) in the below BLUE highlighted areas

TEXT FILE

Business Name Address 1 City, State Zip
< website details will be placed>
Business Name
Address 1
City, State Zip
Phone
< website details will be placed>
< website details will be placed>
Business Name
< website details will be placed>
City
< website details will be placed>

The final output should be creation of 10 TEXT (.txt) files as per the record count in CSV file in the above Text Format.

Please reply me the possibilities...

Thanks for all your help.

 

[drWatson]

No problem. Anytime.

Cheers,
drW