Em Andamento

Plugin for MS Excel 2007

I am using excel for mail merning via Word (merge fields). I am using the "Mapilab Mail Merge Toolkit" plugin for word.

Introduction: I extract data from CRM into Excel lists. These lists are in the format below. I want to "turn" these fields around, so that I have one line per e.g. project or another row like the project row (e.g. list of managers or countries):

CRM extract to Excel

Row 1 Row 2 Row 3 Row 4

Project name Person name Address Email

Project 1 Peter B Silver Street 21 peter@[url removed, login to view]

Project 1 Niels T Blackroad 4 nt@[url removed, login to view]

Project 1 Jan R Sun Street 5 janR@[url removed, login to view]

Project 2 Jens R Grey 2 jens@[url removed, login to view]

Project 2 Robert C Denmark Street 8 Robert@[url removed, login to view]

It should be transformed to

Row 1 Row 2 Row 3 Row 4 Row 5 Row 6 Row 7 Row 8 Row 9 Row 10

Project name Person name 1 Person name 2 Person name 3 Address 1 Address 2 Address 3 Email 1 Email 2 Email 3

Project 1 Peter B Niels T Jan R Silver Street 21 Blackroad 4 Sun Street 5 peter@[url removed, login to view] nt@[url removed, login to view]

janR@[url removed, login to view]

Project 2 Jens R Robert C Grey 2 Denmark Street 8 jens@[url removed, login to view] Robert@[url removed, login to view]

The above is just an example, when we do extracts from CRM it could also be other rows, both like the project name row where the same name are repeated or the other rows are with individual data per field.

Sometimes its also more than 3 records per project, so therefore e.g. there could also be +10 email rows or person rows as an example. The names of the rows are always in line number 1.

The plugin should be with an easy to use interface. E.g. with drop downs about which fields to transform in which way (project way or other rows way).

The code should be descriptive and commented.

## Deliverables

[url removed, login to view] requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.

Habilidades: Instalação de Script, Shell Script, Arquitetura de software, Tradução

Ver mais: translation toolkit, mail merge word excel, contract excel work, contract excel, introduction email example, word merge, transform word, MS excel, word merge excel, extract excel word, email list denmark, data merge word, excel number word, merge excel project, number word excel, extract name email excel, excel extract email data, extract records, excel line work, extract email excel, word excel merge, might plugin, field crm, excel word merge, script extract data excel

Acerca do Empregador:
( 14 comentários ) Copenhagen, Denmark

ID do Projeto: #3041544

Premiar a:

prabby81

See private message.

$34 USD em 14 dias
(6 Avaliações)
2.4

5 freelancers estão ofertando em média $192 para este trabalho

AnkSoftware

See private message.

$170 USD in 14 dias
(19 Comentários)
5.7
jal540

See private message.

$204 USD in 14 dias
(40 Comentários)
5.7
rjavtechnologies

See private message.

$425 USD in 14 dias
(17 Comentários)
4.7
namitasoftware

See private message.

$127.5 USD in 14 dias
(2 Comentários)
0.0