Solved

Automatically put signatures on Access/Word merge docoument

Posted on 2013-01-24
4
816 Views
Last Modified: 2013-01-25
Hi
Can anyone tell me how to get a signature to automatically appear on a merged document like other merged fields.
Everying during the merge processing is working fine (single document and/or bulk documents) except for the signature line. At present the only way I can get the signature to appear on the merged document(s) is to put the cursor on the signature line and press the F9 key.
This is OK for a single document but not acceptable if the user has to print several hundred documents (Certificates etc).
I have attached a sample document (which I hope you can open in MS Word)) that has the IncludePicture mail merge signature graphic, however, after opening the document you may have to press the ALT+F9 keys to display the IncludePicture code that has the full path name and the users signature.jpg . This is located down to the bottom of the document with a message as to what to do.    

As I said - the signature appears if I press F9 so the path/signature is valid but won't appear automatically. Do I need to include something else in the IncludePicture mail merge graphic?
If not is there anyway I can get the signature to appear without the user having to manually intervean
Test-Certificate---Copy.docx
0
Comment
Question by:Adlerm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 51

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 125 total points
ID: 38817752
Hi,

Unfortunately it is a normal behaviour.

You could create a single file with all your certificates, updating it then and printing them after that.

Regards
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 125 total points
ID: 38817877
You can select the whole output document (Ctrl+A) and then press F9. All the contained output records will be updated.
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 38817886
Note that if you are printing directly, there is an option (Options/Display section) to force field updating before printing.
0
 

Author Closing Comment

by:Adlerm
ID: 38818230
Thanks to both of you for your prompt response. The CtrlA + F9 does the trick
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question