#1
|
|||
|
|||
If...Then...Else with text included and INCLUDEPICTURE
Forgive me if this has been addressed before. I searched but i simply do not know what to put in the search to see if its been answered.
IF AMOUNT IS GE= to $5,000.00 and I have insert this text and otherwise filled in. But I also need to include a jpeg sig for the Otherwise. Where at in the rule do I add brackets to include the jpeg? For reference I have attached the rule, along with my master conditional document. You can ignore the rules with the amounts as I am playing around so I'm sure they are wrong. But the last rule is the one with the first attachment. Also I am new to conditional mail merges so please laymans terminology lol |
#2
|
||||
|
||||
You'll need to add the INCLUDEPTURE separately, after creating the code for the text output, or you could create the lot manually from scratch. For example, using Ctrl-F9 for the field brace pairs:
{IF{MERGEFIELD Amount}< 5000 "{INCLUDEPICTURE "https://sanantoniozoo-my.sharepoint.com/personal/tenika_hook_sazoo_org/Documents/Desktop/NXT/Testing/Acknowledgments/Julie%20Sig.jpg}¶ Julie Gross¶ Chief Development Officer" "{INCLUDEPICTURE "https://sanantoniozoo-my.sharepoint.com/personal/tenika_hook_sazoo_org/Documents/Desktop/NXT/Testing/Acknowledgments/Tim%20Sig.jpg}¶ Timothy M. Morrow¶ President & CEO"} where the ¶ represents an actual paragraph break or manual line break. Personally, though, I'd embed the actual images in the mailmerge main document, thus: {IF{MERGEFIELD Amount}< 5000 "[Julie_Sig.jpg]¶ Julie Gross¶ Chief Development Officer" "[Tim_Sig.jpg]¶ Timothy M. Morrow¶ President & CEO"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I tried your 1st suggestion putting page breaks but when i do that it jumps everything down to a new page. When i tried to merge to see if that worked for one of them it didn't. I just don't understand. But I thank you for your help.
|
#4
|
||||
|
||||
The instruction referred to:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to hyperlink sentence from text that got included through {INCLUDETEXT \\....docx} | thosecars82 | Word | 1 | 06-19-2017 04:33 AM |
PPT 2016 - to video with text to speech included ? help | warn1936 | PowerPoint | 0 | 02-04-2016 02:00 PM |
Macro to select an { includepicture } field code and format the picture behind text and 100% scale | sanpedro | Word VBA | 3 | 03-30-2015 10:50 PM |
Need help counting text into separate columns. Screenshot Included | blackjack | Excel | 5 | 09-04-2014 10:49 PM |
Macro or Function to know wether a string is included in a text | Eduardo | Word VBA | 5 | 06-15-2009 01:55 AM |