mail merge word

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Word Training and help » Mail Merge in Word 2007

Mail Merge in Word 2007

resolvedResolved · Medium Priority · Version 2007

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

Fri 17 Aug 2012: Automatically marked as resolved.


 

Word tip:

Realign text quickly

There are shortcut keys you can use to quickly realign text in Word:

- To center-align,: Ctrl + E
- To left-align: Ctrl + L
- To right-align: Ctrl + R.

Simply click inside the paragraph you wish to realign and use the appropriate shortcut keys.

View all Word hints and tips


Server loaded in 0.08 secs.