Replies

Thanks RG
Looks better than what I was proposing
However, having got all the code in it now will not recognise any users and we just get the VBWarning with a blank userform in behind, which is correct because it has been instructed to not show anything until the user is verified.

I have set myself as the “Supervisor”

Mmmmmm!!!!!!!!

RG
The purpose of this is for the users or their assistants to select signatures to attach to documents. I have created a user form with 10 signatories listed and have used OptionButtons to select, hence the Case statements.
The user, in this case, is Sharon and the secretary is Jen.

RG hi again
I decided to go with your suggestion but am having problems getting it to work.
I have defined the variable zUserName,

Dim zUserName As String

zUserName = Environ(“UserName”)

and used it like this

Case OptSharon
If zUserName = “Sharon Thomas” Or “Jen Ferguson” Then

Selection.InlineShapes.AddPicture FileName:= _
“P:_IANZCorporateServicesBusinessServicesGraphicsSignaturesSharon Thomas.jpg” _
, LinkToFile:=False, SaveWithDocument:=True

With ActiveDocument.InlineShapes(ActiveDocument.InlineShapes.Count)
.LockAspectRatio = msoTrue
.Width = CentimetersToPoints(2.5)
End With
Else
MsgBox “You do not have permission to use this signature!”, 48
End

What am I doing wrong?

Paul
Your suggestion fixed the problem. Thanks for that.
Completely forgot about that setting!

It has been very frustrating as the document turned out to be 45 pages instead of 29 and the comments column is too small to write in!!

Charles
Can I get you to look at the attached document with IF fields that I can’t seem to get to work, it’s driving me nuts!

Sorry for the delay been away for 7 days.

Doesn’t seem to work

Andrew a final question for you
If I place the bookmark, bmk010ProgrammeType, inside another bookmark, bmkTest, and using the REF field { REF bmkTest }, shouldn’t this return the value of bmk010Programmetype?

Andrew
I am trying to do it without using any code in the template

Andrew
That is correct they are only placeholders until the document is merged from the CRM. It is then that I want to use the results to compare and insert Autotext based on the result

Andrew
I think I understand what you are saying but not sure how to apply it.
This is the xml code used in our CRM for extracting data and placing it at the bookmark bmk010ProgrammeType in a report template,

Is it the function that I have highlighted that needs to be changed?

The document (attached) is one to test the bookmark outputs from our CRM.

The bookmark used for the IF statement is the sixth on the page I have also tried to use this for the REF field.

Charles hi
Can’t seem to get this to work.
40464-Bookmarks

Andrew thanks again
Works a treat.
Thought about the problem and seem to remember there was a reason for “hiding” the watermark but can’t remember.

Andrew hi
As I stated in the original post the report was designed to be printed o expensive bond paper when finalised. It contained a logo on the front page, hence the remove the logo “shape”, and “DRAFT” watermarks. The intention of the code was to remove the logo and watermarks.
Ideally we would like to remove the watermarks, which are only imbeded shapes

Andrew
The document is a hard copy of the code which is stored in a global template but used on the attached typical report