Jane has attended:
Word Intermediate course
Word Advanced course
Excel Charting course
Excel Dashboards for Business Intelligence course
Excel Advanced - Formulas & Functions course
Mail Merge in Word 2007
I need to create a mail merge document to include calculations/formulae. e.g. If a value in one of the excel cells to be merged is greater than zero, I need to include a sentence in the merge document that will merge that value into the document. If, however, the value in the excel cell is null or zero, I need to exclude the sentence from the merge document altogether. I understand that this can be achieved using IF statements. Any guidance for this would be appreciated. Thank you.
RE: Mail Merge in Word 2007
Hi Jane
Thanks for your post and yes we can probably assist you in finding a solution to effectively create conditional merge fields in Word.
However this type of work does fall beyond the means of this forum and into a more consultative area.
We would ask you to send us some working examples of your files along with a brief overview of one merged field you are looking to create. We can then review and if we feel a solution can be found we can advise you on how much time we will need and associated costs.
If you would like to take this further please do reply to my email.
Kind regards
Jacob
