Hi I am a newbie to VBA and my 1st post on this forum, I am trying to create a MailMerge excel file to be used in Word.
Right now the data is like this
Company Name Address DUNS #
WORKSHIFT SYSTEMS CORP 373 Poulin Avenue 251290813
OTTAWA
K2B 5V2
XBASE TECHNOLOGIES CORP 20 Eglinton Avenue West 248627911
Suite 1300
Box 2006
Toronto
I want this data to go into columns like this. 1 Row for each record so that I can export it into excel and use it for mailmerge.
Company Name Address Address2 Address3 Zip City DUNS #
WORKSHIFT SYSTEMS CORP 373 Poulin Avenue OTTAWA K2B 5V2 251290813
XBASE TECHNOLOGIES CORP 20 Eglinton Avenue West Suite 1300 Box 2006 Toronto
Is there an easy way to achieve this ? I dont want to do it manually as it has some 16000 rows.
Regards
Tinku