Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-13-2016, 05:26 AM
neoported neoported is offline INCLUDETEXT is file doesn't exist Windows 10 INCLUDETEXT is file doesn't exist Office 2013
Novice
INCLUDETEXT is file doesn't exist
 
Join Date: Jul 2016
Posts: 2
neoported is on a distinguished road
Default INCLUDETEXT is file doesn't exist

I'm looking to include a merge field that pics up a Windows user's signature based on their login name and whilst I've got a macro to pick up the username and replace the @@WinUsername@@ bit.

It's working if the user's signature file exists but it produces an "A field calculation error occurred in record 1" if the file doesn't exist and it's looking to display the default.docx file.

It then includes the default.docx file as required. Just looking to get rid of the error message.

So, inspite of my ramblings I'd like to inclde a file if it exists and if it doesn't to include a default file instead of the Error file not found message. Is this possible.

Below is my work in progress

{IF


{ INCLUDETEXT "Q:\\Letters\\Signatures\\@@WinUsername@@.docx "} ="Error*"
{ INCLUDETEXT "Q:\\Letters\\Signatures\\default.docx"}
{ INCLUDETEXT "Q:\\Letters\\Signatures\\@@WinUsername@@.docx "}
}

Thanks in advance
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and paste file but folder doesn't update Haha88 Windows 2 09-24-2015 09:54 AM
INCLUDETEXT is file doesn't exist INCLUDETEXT dynamic file name? kwstewart Mail Merge 3 08-17-2015 09:04 AM
A text box (active X) control doesn't work on reopening the file Chris Baker PowerPoint 1 06-07-2013 05:51 AM
INCLUDETEXT is file doesn't exist The printed pdf file doesn't print an equation inside text box! why? Jamal NUMAN Word 4 07-01-2011 06:27 PM
[PowerPoint 2010] Change font for all slides in an exist *.PPTX file LongTTH PowerPoint 0 12-15-2010 02:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:00 AM.


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