+ Reply to Thread
Results 1 to 5 of 5

Inserting data from table in Word template and create wod/pdf documents

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    Karlstad / Sweden
    MS-Off Ver
    Excel 2003
    Posts
    23

    Inserting data from table in Word template and create wod/pdf documents

    Hello, me again with problem of the day.

    I have a word document that I manually update with info from 3 linked tables in Access where I change some text and pictures (basically a diploma with recipients name, name of award and picture of it, a citation and date and lastly a serial no (which is also the file name of the exported pdf).
    I've looked around and haven't found anything that I've understood or seems to help, but surely this task should be possible to automate in some way by taking the queried data and inserting at appropriate places in the document and save (preferably using the serial no as name and in pdf format).
    All the linking info I find seems to be for excel (not good for the picture content) and involves email addresses and similar.

    If anyone know how to solve this and give me a step by step or at least general guide on how to do it I would be a very happy camper!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,179

    Re: Inserting data from table in Word template and create wod/pdf documents

    I can think of two solutions to this.
    1. In word build a merge that takes the data from your queries and imports them into your word document.
    http://office.microsoft.com/en-us/ac...001233657.aspx

    2. The other solution involves doing it all in Access. Look at this video on how to do that.

    http://www.datapigtechnologies.com/f...einreport.html

    Good luck with whichever one you choose.

  3. #3
    Registered User
    Join Date
    02-11-2013
    Location
    Karlstad / Sweden
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Inserting data from table in Word template and create wod/pdf documents

    Thank you I figured it out and it works (almost).
    One caveat.. for some reason the last line of my template containing one of the inserted data bits ends up top of next page every time I run the merge despite everything looking good on the preview. I can't figure out why this keeps happening.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019; O365
    Posts
    19,179

    Re: Inserting data from table in Word template and create wod/pdf documents

    You might want to reset the margins and see if that helps.

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

    Re: Inserting data from table in Word template and create wod/pdf documents

    Quote Originally Posted by SteinerKD View Post
    Thank you I figured it out and it works (almost).
    One caveat.. for some reason the last line of my template containing one of the inserted data bits ends up top of next page every time I run the merge despite everything looking good on the preview. I can't figure out why this keeps happening.
    Mailmerge previews don't reliably reflect the merged layout. What you may have happening is a combination of one of your mergefields causing a line wrap and the use of empty paragraphs below it to space the content out. To avoid this, you should consider using a multi-row borderless table with sufficient row heights for the variable data to wrap without affecting vertical positioning of the rows below.
    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)

Tags for this Thread

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