Populating a Word document with VBA\SQL

shabbaranks · #1 07-14-2015, 06:43 AM

Im slowly getting there (and slowly learning more about Word so thanks...!!)

I have used the ctrl f9 function to create the { and written the code in between as per the image below. Whats happening now is if I open the document I am prompted to insert the job number (it asks me a few times) and then when it stops the job number is empty and the other fields relate to a completely different job number... humph

macropod · #2 07-14-2015, 07:22 AM

Quote:

Originally Posted by shabbaranks

Whats happening now is if I open the document I am prompted to insert the job number (it asks me a few times) and then when it stops the job number is empty and the other fields relate to a completely different job number

The multiple prompts suggests either:
• you have have more than one FILLIN field in the document; and/or
• you are using a Word template rather than a mailmerge main document.
You should also have a space after the '<>' in the SKIPIF field.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Populating Data in New TABs?	Sueade	Excel	2	06-02-2015 09:12 PM
Mail Merge Field Not Populating	JennEx	Mail Merge	3	05-10-2015 09:30 PM
Populating a table cell wit document properties	milena	Word VBA	2	04-15-2015 07:28 AM
Reapting/Populating the same text in Word 2007	akwjaw14	Word	0	06-03-2014 03:40 PM
$Populating a Word document with VBA\SQL$ Need help populating dropdown box	antztaylor	Word	3	11-06-2012 05:46 PM