Eliminate blank lines in Microsoft Word Mailmerge when field is blank.
$30-250 USD
Ditutup
Disiarkan hampir 6 tahun yang lalu
$30-250 USD
Dibayar semasa penghantaran
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.
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 determine the concept that is trying to be shared by the customer.
Proposed Milestones
$155 USD - Initial
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
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 today?
i read your deatials and understand all requritment what you wnat.
i am sure i can give you fantastic work.
.
Thanks
sunil
Proposed Milestones
$30 USD - GRAPHIC ESIGN
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 Experience
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
Proposed Milestones
$35 USD - word work
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 Mailmerge when field is blank.
I have a positive record of accomplishment of regularly delivery punctual and high-quality assignments for my customers. I have an in-depth understanding of this topic.
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
Eliminate blank lines
Proposed Milestones
$32 USD - Eliminate blank lines
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 completed many projects . Hire me for fast and reliable service
Proposed Milestones
$155 USD - safe pay