?
Solved

Automatically put signatures on Access/Word merge docoument

Posted on 2013-01-24
4
Medium Priority
?
818 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 52

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 500 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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

752 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