dawnoharding
New Member
- Joined
- Sep 17, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a customer database from our system. The customer database is company details for example column A is company reference, column B is company name, column C is address etc. The last columns contain multiple email addresses for example column D, E, F etc. So all the email addresses for the company are listed in the same row. Some rows will have a couple of addresses and some go up to about twenty email addresses.
For my email management software, I can only have one email address per row when importing. I therefore need to be able to create a way to create a row for each email address and pull the company details in to the new row.
I am sure there must be a way but can't work it out.
Hope it makes sense any help would be great
For my email management software, I can only have one email address per row when importing. I therefore need to be able to create a way to create a row for each email address and pull the company details in to the new row.
I am sure there must be a way but can't work it out.
Hope it makes sense any help would be great