Fermé

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

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.

Compétences : Révision, Microsoft, Microsoft Office, Word, Traitement de texte

en voir plus : suppress blank fields in mail merge word 2016, mail merge skip blank fields word 2016, word 2013 mail merge skip field if blank, suppress blank lines in mail merge word 2010, word 2016 mail merge blank lines, how do i remove blank fields in a word 2016 mail merge?, remove blank lines in mail merge word 2016, suppress blank lines in mail merge word 2016, send document microsoft word microsoft works, sending microsoft works page microsoft word document, microsoft word experts, microsoft word type service mark, microsoft word macro tick, convert microsoft word forms pdf, microsoft word expert, open microsoft word com, converting microsoft works microsoft word, microsoft word file permission error, creating microsoft word template, freelance highly proficient microsoft word

Concernant l'employeur :
( 6 commentaires ) Farmington, United States

Nº du projet : #17367515

25 freelance font une offre moyenne de $99 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(50 Commentaires)
5.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(47 Commentaires)
5.1
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(13 Commentaires)
4.8
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(38 Commentaires)
4.6
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(13 Commentaires)
3.8
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
3.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
3.0
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(6 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
1.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
1.0
aleyerkovic

Hello, I would love to help you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
sachinimadurai4

Exce2 skills in Microsoft apps formats

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
midas0925

I hv rich experiences in word for 15 years. Relevant Skills and Experience my word skill is better than the others... Proposed Milestones $111 USD - don't worry

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
shaikatshaikat96

sir i read your description and i know this work very [login to view URL] u hire me than u will get the great service ever.i have a 2 year experience in this type work and i am new comer in freelancer.com . Relevant Skills and Ex Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
LOSPOS77

Hi, My proposal is in regards to Eliminate blank lines in Microsoft Word Mailmerge. Relevant Skills and Experience I'll be using my own experience of last 5 years and relevant skills to come up with the desired resu Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0