Hi experts,
Wondering how to convert ~2000 txt records into rows in a table for refining, then doing email merge and import into email programs etc. For each record, 12-16 out of 16 attributes would be available. I have two columns of text, where Column B holds the actual values for each record, e.g. like this:
[COLUMN A] [Column B]
FULL_NAME Bill Bronco
SUFFIX CPA
CATEGORY #Prospect
EMAIL bill@bronco.com
BUSINESS_PHONE 61 3 9876 5432
JOB_TITLE COO
DEPARTMENT Operations
COMPANY Acme Ltd
BUSINESS_STREET Level 2, 18 Lindfield Terrace
BUSINESS_CITY Lindfield
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2909
FULL_NAME Hannah Harvest
SUFFIX ORD
CATEGORY #Customer
EMAIL h.harvest@live.com
BUSINESS_PHONE 61 3 5432 1234
MOBILEPHONE 61444555666
JOB_TITLE Recipe developer
DEPARTMENT Production
COMPANY Country Origin Ltd
DIRECT_MANAGER Harry Handy
BUSINESS_STREET 8 Sandy Road
BUSINESS_CITY Harboard
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2130
FULL_NAME Karl Kraftsman
SUFFIX COOP
CATEGORY #Competitor
EMAIL kk@outlook.com
BUSINESS_PHONE 61 7 6789 5432
JOB_TITLE Heavy Lifter
DEPARTMENT Moving
COMPANY We Load Pty Ltd
DIRECT_MANAGER Rebbecca Responsible
BUSINESS_STREET 1 Beachcombers Way
BUSINESS_CITY Bondi
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2200
Any recommendation on how to do this practically, maybe with VBA?
Thanks,
Soren
Wondering how to convert ~2000 txt records into rows in a table for refining, then doing email merge and import into email programs etc. For each record, 12-16 out of 16 attributes would be available. I have two columns of text, where Column B holds the actual values for each record, e.g. like this:
[COLUMN A] [Column B]
FULL_NAME Bill Bronco
SUFFIX CPA
CATEGORY #Prospect
EMAIL bill@bronco.com
BUSINESS_PHONE 61 3 9876 5432
JOB_TITLE COO
DEPARTMENT Operations
COMPANY Acme Ltd
BUSINESS_STREET Level 2, 18 Lindfield Terrace
BUSINESS_CITY Lindfield
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2909
FULL_NAME Hannah Harvest
SUFFIX ORD
CATEGORY #Customer
EMAIL h.harvest@live.com
BUSINESS_PHONE 61 3 5432 1234
MOBILEPHONE 61444555666
JOB_TITLE Recipe developer
DEPARTMENT Production
COMPANY Country Origin Ltd
DIRECT_MANAGER Harry Handy
BUSINESS_STREET 8 Sandy Road
BUSINESS_CITY Harboard
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2130
FULL_NAME Karl Kraftsman
SUFFIX COOP
CATEGORY #Competitor
EMAIL kk@outlook.com
BUSINESS_PHONE 61 7 6789 5432
JOB_TITLE Heavy Lifter
DEPARTMENT Moving
COMPANY We Load Pty Ltd
DIRECT_MANAGER Rebbecca Responsible
BUSINESS_STREET 1 Beachcombers Way
BUSINESS_CITY Bondi
BUSINESS_STATE NSW
BUSINESS_POSTCODE 2200
Any recommendation on how to do this practically, maybe with VBA?
Thanks,
Soren