×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Document Merge Task

Document Merge Task

Document Merge Task

(OP)
Office 2013 Pro with Access/Word/Excel/Outlook

Built a Web Form which exports form data as an XML file ... this file is sent via email as an attachment ... Access imports these files directly from Outlook

The challenge is getting one of the XML fields which is a dynamic multi-line text field containing a list of names in the form: Last Name, First Name to provide a signing line on a Merged Document ... currently in Word, I have a reference <<names>> which outputs this field in the form

Last1, First1

Last2, First2

.

.

.

LastN, FirstN

The Word Mail Merge Wizard quickly allows me to link directly to the table containing the XML data ... once linked it was simple to create a template that positions the data with the intent that it be printed out for signatures ... unfortunately the list of names, being dynamic, creates a challenge as there doesn't appear to be any additional format options for the field reference <<names>> ... ultimately trying to add a dynamic signing line either in front of or behind the Name on each line.

Last1, First1 __________________________________________

Last2, First2 __________________________________________

Last3, First3 __________________________________________

As a real kludge I could add "_______________________" as text to the Field data on the Web site but would rather have a local Template solution.

Just wondering if there is possibly another way (simpler) to go about this ... with Office 2003 I used to use Excel and VBA routines to do merging but was hoping that there would be an easier way with newer versions of office.






RE: Document Merge Task

What you're asking for is not possible with a mailmerge.

Cheers
Paul Edstein
[MS MVP - Word]

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close