#16
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#17
|
|||
|
|||
Thank you for your guidance with this. I actually got it to work, what I did was use the ctrl9 to get my double brackets. I then typed IF and without spacing after IF, I inserted the merge field and completed my formula, then I would highlight the formula and then toggle to get the MERGEFIELD to appear. I still was receiving both names instead of replacing, so I did more research and followed this tip: I highlighted the inserted merged field as well as the name I did not want. I then book marked them, and went to format/font/hidden . . . worked perfectly. Names are still in the background but are not visible.
My biggest concern is that this template may be used by many individuals and when I open the template is not visible, even unhidden fields. Is there a way that the unhidden formula can be visible when opening the template so it does not accidently get deleted or is making it a read only the best option. . . only problem with this is I may not have all the names of individuals to specify who has and who does not have rights. Thanks again for your guidance. |
#18
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#19
|
|||
|
|||
If someone can advise of another issue regarding this process, that would be great. The template is in Times Roman 11 font, and all inserted field data comes from the same database, but I noticed when the mail merge is complete, some of the names brought in are in TR 12 font and some are in TR11. I also noticed that with some of the finished letters, there is an extra row, e.g.,
Should be: Enclosure: ABC: AB What I'm getting but not on all letters: Enclosure: ABC: AB Thanks again. |
#20
|
||||
|
||||
Without seeing the actual document, it can be difficult for anyone to diagnose the issue. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF statement in Word VBA | BristolJGM | Word VBA | 2 | 09-16-2017 06:02 AM |
and if statement in word mailmerge | sbye | Mail Merge | 17 | 08-25-2017 09:59 PM |
VBA Word - Find & Apply Styles to Specific Words - Using Case Statement | jc491 | Word VBA | 17 | 12-26-2015 12:25 PM |
Microsoft Word IF statement issues | micro44 | Word | 4 | 10-23-2014 12:10 PM |
Help with IF statement in word 2010 | Mad | Word | 2 | 04-06-2013 06:31 AM |