Hi! I'm new here at this forum.
I'm a Norwegian IT tech with 15 years of experience, and now I'm working at a consultant brokering company making CV templates for external companies.
We're using Mail Merge to populate these templates, and it works like a charm. However, a new client have a request that seems "impossible" to meet with Mail Merge, but I have a feeling that there is a way.
The way a Project-based CV usually is constructed, is that you list all projects like this:
-----
Project name - Customer
Date
Description
Consultant role
Applied Skills
Project name - Customer
Date
Description
Consultant role
Applied Skills
Project name - Customer
Date
Description
Consultant role
Applied Skills
--- Etc...
The new Client want something like this:
---
Current Employer
Project name - Customer
Date
Description
Consultant role
Applied Skills
Project name - Customer
Date
Description
Consultant role
Applied Skills
Project name - Customer
Date
Description
Consultant role
Applied Skills
Another employer
Project name - Customer
Date
Description
Consultant role
Applied Skills
Project name - Customer
Date
Description
Consultant role
Applied Skills
--- etc
Any thoughts on how I can get this to work with an IF-statement? Like Looping inside a loop, then continuing to next "employer" when there is a new value?
We have all the required data fields, but I can't figure out how to do this...