Hello all!
What I have done is, I used a query to pull the data I needed, which is basically jsut the part#, part description, and the image file (Which is only 1.jpg, and stored in the database). So what I did was I set another column with concatenate and put the file location and the image jpg file in this column. Also put the "\\" for each "\" in the file location.
I went over to Microsoft Word, did the {includepicture "{mergefield image_location}" \*mergeformat\d}, press f9, and it gives me all the "The linked image cannot be displayed etc"
So my initial thoughts were, I dont think it's grabbing the "\\" in the first part where its getting the location. Which I was right. It's putting "\" instead of "\\" because it is on a different server, so I thought putting another "\" would work (making it "\\\"), but it didn't, put another "\" ("\\\\") and still didnt work.
What my problem is, I'm trying to make this user friendly and all they would have to do is filter the parts they need, press the macro. and all they would need to do open the word document it and also fills the labels with the part#, part description, and picture. My only trouble right now is the picture that I can't understand.
Does anyone have any experience with this? Please let me know, thank you!
What I have done is, I used a query to pull the data I needed, which is basically jsut the part#, part description, and the image file (Which is only 1.jpg, and stored in the database). So what I did was I set another column with concatenate and put the file location and the image jpg file in this column. Also put the "\\" for each "\" in the file location.
I went over to Microsoft Word, did the {includepicture "{mergefield image_location}" \*mergeformat\d}, press f9, and it gives me all the "The linked image cannot be displayed etc"
So my initial thoughts were, I dont think it's grabbing the "\\" in the first part where its getting the location. Which I was right. It's putting "\" instead of "\\" because it is on a different server, so I thought putting another "\" would work (making it "\\\"), but it didn't, put another "\" ("\\\\") and still didnt work.
What my problem is, I'm trying to make this user friendly and all they would have to do is filter the parts they need, press the macro. and all they would need to do open the word document it and also fills the labels with the part#, part description, and picture. My only trouble right now is the picture that I can't understand.
Does anyone have any experience with this? Please let me know, thank you!
