+ Reply to Thread
Results 1 to 5 of 5

Provide eSignature on Mail merge Document

  1. #1
    Registered User
    Join Date
    05-16-2019
    Location
    Tampa, Florida
    MS-Off Ver
    MS Office 365
    Posts
    19

    Provide eSignature on Mail merge Document

    This question is a little bit larger than just spreadsheets but since it begins in Excel I thought that I would start in this forum.

    I have a spreadsheet with employee names, titles, manager name, email and other employee related information. How would I take this information, combine it with some boilerplate text and output each employee’s information to that individual employee so they could review their demographic data and provide an e-signature? I originally thought "Word Mail Merge," but now I'm not so sure, especially since it involves an e-signature, of which I have no understanding.

    Thank you.
    Last edited by AliGW; 02-11-2020 at 09:58 AM.

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    9,727

    Re: Mail Merge from Excel or something else?

    Hi
    could you possibly add in your title (edit your first post and change the title) that you need an e-signature for merged documents? ( something like " provide an e signature on mail merged documents" )
    I cannot edit your post due to forum glitch.
    I will move this thread to the Word sub-forum.
    Thanks
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2019 (Win 10 - Work) & 365 Subscription Insider (Win 10 - Home)
    Posts
    35,393

    Re: Provide eSignature on Mail merge Document

    I've done it, Pepe. All you have to do is copy the text before editing the post and paste it back in.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    9,727

    Re: Provide eSignature on Mail merge Document

    Thanks Ali.

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,245

    Re: Provide eSignature on Mail merge Document

    You can certainly generate the document to be reviewed by each employee using mailmerge, but only they could add their eSignatures to the documents they return. For that, see: https://support.office.com/en-us/art...A-719C8B3F1A2D

    For some code to render the mailmerge output as a separate document for each employee, see the Send Mailmerge Output to Individual Files topic in the Mailmerge Tips and Tricks thread at: http://www.msofficeforums.com/mail-m...ps-tricks.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1