locked
Fill Word Contract fields with Excel data RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello.

    I have a contract with some blank fields and I need to fill them with a external excel data that I have.

    I saw some workarounds by copying and pasting special, but it's not dynamic as I need.

    I need something more automatic and dynamic, that doesn't need manual intervention.

    How can I do it?

    Thanks.

    Frederico Moyses

    FGM Solucoes em Tecnologia.

    Tuesday, December 11, 2012 12:19 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Mail merge.
    Tuesday, December 11, 2012 2:01 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Could you be more specific? Do you have some reference (link)? Thanks for your answer. Frederico Moyses

    Frederico Galinari Moyses FGM Soluções em Tecnologia

    Tuesday, December 11, 2012 2:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You don't say which version of EXCEL / WORD you are using but check this out:-

    http://office.microsoft.com/en-gb/word-help/word-2007-training-courses-HA010215566.aspx?CTT=1

    Go to section 6 in the above:-

    6. Use mail merge

    Tuesday, December 11, 2012 2:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Im using Office 2013, but I can try with Office 2007 as shown on the link you've sent me. I'll try and post the results here. Thanks a lot.

    Frederico Galinari Moyses FGM Soluções em Tecnologia

    Tuesday, December 11, 2012 2:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for your help. It helped me a lot!

    Have a nice week.

    Frederico Galinari Moyses FGM Soluções em Tecnologia

    Wednesday, December 12, 2012 12:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Another question.

    I've some fields on excel that are currency, like: R$8.159,86.

    When I merge it into word document with merge cells, it comes like: 8159,862

    How can I get EXACLTY the same number that is shown on Excel field? 

    Thanks!

    Frederico Galinari Moyses FGM Soluções em Tecnologia

    Wednesday, December 12, 2012 7:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Frederico - you need to raise another issue for that because it's a different question.
    Wednesday, December 12, 2012 8:21 PM