Eliminate blank lines in Microsoft Word Mailmerge when field is blank.
$30-250 USD
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.
Nº del proyecto: #17367515
Sobre el proyecto
23 freelancers están ofertando un promedio de $98 por este trabajo
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
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.
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
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
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
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.
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
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