What if statements in word 2007

There are no pre-defined fields for the membership number and membership type, but don't worry about that. The pre-defined map is a shortcut that you'll want to take advantage of when possible, but it won't always have every field you need.

You can get around the lack of a pre-defined mapping field by inserting an unmapped merge field--so don't forget to insert both of those fields before you continue.

At this point, all of the merge fields are in place, and you could run the merge. However, the membership details in the Excel workbook--F, Fr, and I--might not mean anything to the new members. So, let's replace that merge field with an IF field that can turn that meaningless data into something the members understand. If you run the merge as is, the membership type merge field will return F, Fr, and I, which you'll probably want to avoid.

This next bit might feel like unchartered waters if you're not familiar with Word fields. In a nutshell, they're pre-programmed codes similar to the merge fields you inserted earlier. In this case, we're using the following nested IF fields:. Inserting these fields is a bit awkward--at first. If you prefer, click Preview results in the Preview results group to review the merge before you commit it to finished documents.

In this case, there should never be an empty membership type value, but if that happens, you'll want to accommodate that by adding an additional IF. Notice that the three IF fields are nested , one within another--that syntax is important.

There are other ways we could modify this letter using conditional fields instead of the merge fields. For example, if the membership type value is Fr, you might want to add an additional sentence reminding the new member that the Friends membership includes an additional two guests with each visit. Word's fields are a powerful feature. If you're not familiar with them, considering reading 10 things you need to know about using Word fields. Be your company's Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets.

Delivered Mondays and Wednesdays. I answer readers' questions when I can, but there's no guarantee. Don't send files unless requested; initial requests for help that arrive with attached files will be deleted unread. You can send screenshots of your data to help clarify your question.

From the Word Mailings tab, choose "Select Recipients," and then select your data file to open. If you are importing zip codes or currency you will need to do some work within Word to format the data correctly.

OLE lets you choose which worksheet in a workbook you want to use. Custom formats are entered after the field name, within the curly brackets. A "0" zero indicates that if there isn't a digit in that place a zero should be placed there.

A "," means to use the thousands separator when displaying the number. You can also embed conditional IF statements and other Word directives in your formats, which is useful when you are formatting mixed zip-code data. To Format Click the "Trust Cetner Settings" button on the right panel. In the panel on the left, select "Trusted Locations" Check the box "Allow trusted locations on my network not recommended " Select "Add new location You may want to also enable trusting of subfolders.

These settings are sticky: they will stay set until you change them. Stay In Touch. With Information Technology Staff. Snail Mail. The time now is AM. The comments are property of their posters. Author Name. Remember Me? Mark Forums Read. Baggott external usenet poster. Posts: 7. View message headers. Find all posts by Amy E.

Find all threads started by Amy E. Posts: 2, Posting Rules. Similar Threads.