Hi I am trying to create a MailMerge database
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 ?
Regards
Tinku
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 ?
Regards
Tinku