Printable View
Hi,
I am attempting to take certain information from an access database to Microsoft Words labels.
I know about creating word objects etc. I don't know how to create pages of labels via VB.
I will extract the information from the database and manipulate it. I then want to put the names and addresses into word labels. Essentially a mail merge through VB.
Can someone help me out please?
Anyone?
Why can't you just use the mailmerge option in Word? It will allow you to specify the data source. If you need to change the data based on some run time parameter, I would create the word document using dummy data, then create the proper data in VB, then use "shell" to execute the word doc.
I thought someone would mention this. I am doing it for someone else. It would be easier for them to just click a button. Also before the mail merge occurs the database has to be manipulated. It is not my database and was not set up by me. I think it is poorly designed.
That is why i would like to do it via vb. I am more confident with vb than access (vba)
I found something on this forums. How can i adapt it to print labels that are 2 across and 8 down. At the momment it prints just 4 down.
does anybody know?