Cancelado

MS Word Address Handling

Hi,

We have 4 MS Word templates used for generating standard letters via an automated mail merge.?

The address fields are typically:

NAME

AddressField1

AddressField2

Town

PostCode

We need to enhance the templates so that if AddressField2 is blank, the Town and Post Code move up a row - so there is no blank row for addressfield2.

For example, the address currently can look like this if addressfield2 is blank:

"95 Scorer Street

Lincoln

Liniconshire"

where it needs to look like this:

"95 Scorer Street

Lincoln

Liniconshire"

We are looking to quickly fix this issue through VBA scripting.? So the user will run a mail merge to generate the letter or template, the data gets passed to the mail merge fields, we then need to automatically remove address field 2 where blank.

Note that:

Tenant Deposit Receipt - has one address with addressfield2

Property Management Agreement Template - has one address with addressfield2

Notify Gas Provider Template - has two addresses to fix

Assured Shorthold Tenancy Agreement - has three addresses to fix

I have attached the templates.? Please quote to fix the templates.? We are looking to have these fixed asap.

Best wishes

Richard

Habilidades: Engenharia, Microsoft, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Visual Basic para Apps, Área de trabalho do Windows

Veja mais: provider agreement template, property provider, vba for word, word templates, word merge, vba word, vba scripting, scripting word, data handling, word vba agreement, data merge word, vba post, letter word template, merge word, vba data management, php generate word, vba management, word windows, word mail merge php, vba mail merge word, fix code vba, vba property, vba mail merge, need asap letter, generate template word php

Acerca do Empregador:
( 38 comentários ) United Kingdom

ID do Projeto: #3115904

5 freelancers estão ofertando em média $32 para esse trabalho

bfpickford

See private message.

$25.5 USD in 2 dias
(55 Comentários)
5.3
ArWarriach

See private message.

$51 USD in 2 dias
(30 Comentários)
4.7
juan1matos

See private message.

$12.75 USD in 2 dias
(19 Comentários)
4.3
kanhashriinc

See private message.

$42.5 USD in 2 dias
(9 Comentários)
2.9
kratz1984

See private message.

$29.75 USD in 2 dias
(0 Comentários)
0.0