Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2024, 01:35 PM
TCHook TCHook is offline If...Then...Else with text included and INCLUDEPICTURE Windows 11 If...Then...Else with text included and INCLUDEPICTURE Office 2021
Novice
If...Then...Else with text included and INCLUDEPICTURE
 
Join Date: Jan 2024
Posts: 2
TCHook is on a distinguished road
Default 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
Attached Images
File Type: jpg If..Then...Else.JPG (37.6 KB, 14 views)
Attached Files
File Type: docx MASTER Conditional Document.docx (32.2 KB, 1 views)
Reply With Quote
  #2  
Old 01-19-2024, 06:00 PM
macropod's Avatar
macropod macropod is offline If...Then...Else with text included and INCLUDEPICTURE Windows 10 If...Then...Else with text included and INCLUDEPICTURE Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 01-23-2024, 09:39 AM
TCHook TCHook is offline If...Then...Else with text included and INCLUDEPICTURE Windows 11 If...Then...Else with text included and INCLUDEPICTURE Office 2021
Novice
If...Then...Else with text included and INCLUDEPICTURE
 
Join Date: Jan 2024
Posts: 2
TCHook is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 01-25-2024, 05:14 AM
macropod's Avatar
macropod macropod is offline If...Then...Else with text included and INCLUDEPICTURE Windows 10 If...Then...Else with text included and INCLUDEPICTURE Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The instruction referred to:
Quote:
where the ¶ represents an actual paragraph break or manual line break
NOT a page break...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
If...Then...Else with text included and INCLUDEPICTURE 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
If...Then...Else with text included and INCLUDEPICTURE Macro or Function to know wether a string is included in a text Eduardo Word VBA 5 06-15-2009 01:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft