Solved

Automatically put signatures on Access/Word merge docoument

Posted on 2013-01-24
4
813 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
  • 2
4 Comments
 
LVL 50

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

Industry Leaders: 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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
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.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
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…

713 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