Eliminate blank lines in Microsoft Word Mailmerge when field is blank.

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

Overview: Modify the existing WORD template to suppress blank lines if no data present. Requires someone with ADVANCE Microsoft WORD skills using MailMerge

The attached file, [login to view URL] and [login to view URL] are used to generate a catalogue of classmates and their information. Some of the classmates supplied answers to a biography questionnaire which needs to be printed. The attached [login to view URL] word document is ok, but it does not suppress a line if information is missing. It is desired that if there is no information for a particular questions, both the prompt, answer, and extra line are suppressed.

A sample of the merge field used is:

{ IF { MERGEFIELD Memo2Data } > “A” {MERGEFIELD Memo1Data] “” }

{ IF { MERGEFIELD Memo2Data } > “A” {MERGEFIELD Memo1Data] }

Both the above still produce a blank link if the field Memo1Data is blank

Mail merge is accomplished by connecting [login to view URL] to [login to view URL] and connecting to Query-MemoryBook

Key items to retain in the merge

1) One (and only 1) blank line between each of the bio questions

2) Different font and size of the question and the response

3) Suppress of the prompt, response, and the blank line if there is no response

4) Suppress of Spouse, Address1, Address2, City,St, Phone, email if there is no information (can NOT use the address block item)

5) Retain use of a table (but may modify table to have a separate row for each question. Do not break a question/response for a particular question across pages

6) Photographs will be inserted in the table at the top ()I will do this)

7) Need to retain capability to ‘toggle field codes’ and edit

8) Can not modify the query or selection

As an alternative to using Microsoft Access, the data file has been exported to Excel and may be used instead.

TIMING: Need completed word document asap (within 8 HOURS). PROJECT MUST BE COMPLETED NOT LATER THAN 07/16/2018 BY 12:00 GMT.

Edición Microsoft Microsoft Office Word Procesamiento en Word

Nº del proyecto: #17367515

Sobre el proyecto

23 propuestas Proyecto remoto Activo hace 5 años

23 freelancers están ofertando un promedio de $98 por este trabajo

Dorthy24

Hello, I consider myself a skilled writer that strives to make the customer happy and completely satisfied. Relevant Skills and Experience Since I have excellent grammar and spelling capabilities, I am able to determi Más

$155 USD en 3 días
(51 comentarios)
5.9
SBITServices

Hello Tim, I have checked the attached files and i understand the work. I can do this work. Relevant Skills and Experience MS word Proposed Milestones $35 USD - Intial

$35 USD en 1 día
(48 comentarios)
5.0
LidijaP

I am expert who knows the value of time, very hard working and always delivers the work on time. Stay tuned, I'm still working on this proposal.

$100 USD en 3 días
(14 comentarios)
5.1
SGSgraphics

Hello what are you doing today? i read your deatials and understand all requritment what you wnat. i am sure i can give you fantastic work. . Thanks sunil Relevant Skills and Experience Hello what are you doing to Más

$30 USD en 1 día
(15 comentarios)
4.8
articreations

Hello how are you doing today i see you details of project related to word work i can do this and will complete this as soon as possible. hope you will contact with me and we will work together Relevant Skills and Ex Más

$35 USD en 0 días
(29 comentarios)
4.8
sonarkaushik

I will complete this formatting well before due time I am rea to start Relevant Skills and Experience MSword, mailnerge Proposed Milestones $155 USD - All

$155 USD en 0 días
(6 comentarios)
3.2
binyameen441

hi there i have checked your profile description and understand every thing message me for further details. Stay tuned, I'm still working on this proposal.

$155 USD en 3 días
(2 comentarios)
2.2
WriterMzitoo

I can help you merge the documents as per the instructions given above Relevant Skills and Experience Academic research and Article writing Proposed Milestones $155 USD - Eliminate blank lines in Microsoft Word Mailm Más

$155 USD en 3 días
(2 comentarios)
1.9
aleyerkovic

Hello, I would love to help you

$155 USD en 3 días
(1 comentario)
0.4
graphicvogue

Hello, I am a graphic designer by profession for almost 5 years. I am very dedicated and read your project description carefully for Eliminate blank lines Thanks and regards, Ritu Relevant Skills and Experience E Más

$32 USD en 1 día
(0 comentarios)
0.0
krish041

Hi, I read your post and understood it very well I can finsh this project on time . I gurantee you for the completion of work on time . Relevant Skills and Experience I have vast experience of word and I have complete Más

$155 USD en 3 días
(0 comentarios)
0.0
sachinimadurai4

Exce2 skills in Microsoft apps formats

$155 USD en 3 días
(0 comentarios)
0.0