Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Ole Objects inserted into Word
I am utilizing Access97 and Word 2000. I have set up processes in Access
that creates a table that I utilize to open Word and create a Mail/Merge document in Word. This process works great! What I am trying to do is to add a field to our User table set up as an Ole Object and add a signature to the field. From there I have scanned the signatures and it all seems to be working fine until I get to WORD. In Word I add the field into the document as a Mail/Merge field and when I run the document, all that comes up is letters and numbers i.e. "1507DC04" This is just a sample. How do I insert an Object into a Mail/Merged Word document? Thanks, Phill |
#2
|
|||
|
|||
How do I insert an Object into a Mail/Merged Word document?
Word doesn't have a facility to do this. Your best bet as far as Word is concerned is to store theimages in a format Word can use (.e.g. .jpg, .bmp) in a normal foler in Windows, and store either the filename or pathname in your database in a field called picturefile or picturepath, say. Then in Windows you can use a nested merge field such as { INCLUDEPICTURE "c:\\mypictures\\{ MERGEFIELD picturefile }" } or { INCLUDEPICTURE "{ MERGEFIELD picturepath }" } Use Google groups to find other recent messages containing INCLUDEPICTURE and MERGEFIELD to find more info. on this. In fact there are two ways you can insert your images into Access and neither of them works with Word, but if you are going to store a lot of them in there anyway I suggest you change the way you are doing it. You might want to ask about this in an Access group, but the trouble is that the way you are doing it wraps the image in an OLE wrapper which is specific to the program set up on your machine to handle the type of graphic (.jpg, whatever) you are storing, then (as far as I can remember) inside an Access wrapper). So if for example you move the application to a machine which does not have that application, the images cannot be displayed. Worse, if you are working with (say) Office 2000 and upgrade to Office 2003 you may find that that application is replaced by something which cannot handle the wrapped images. There's another way to store the images by using code to store the unwrapped image in a memo or OLE field. I don't know what the implications of that are for your Access application As far as Word mailmerge is concerned, it does not /really/ help, but it does then become possible to insert the images during a Word 2002/2003 mailmerge by using ADO code in a Mailmerge event handler. Peter Jamieson "SmogerP" wrote in message ... I am utilizing Access97 and Word 2000. I have set up processes in Access that creates a table that I utilize to open Word and create a Mail/Merge document in Word. This process works great! What I am trying to do is to add a field to our User table set up as an Ole Object and add a signature to the field. From there I have scanned the signatures and it all seems to be working fine until I get to WORD. In Word I add the field into the document as a Mail/Merge field and when I run the document, all that comes up is letters and numbers i.e. "1507DC04" This is just a sample. How do I insert an Object into a Mail/Merged Word document? Thanks, Phill |
#3
|
|||
|
|||
In my Access table I created a text field called Signature, Text (250). In
the text field I put the value of "c:\\Claims Processing\\App\\scantest2.bmp". In my word document I put: { INCLUDEPICTURE «Signature» } and when the mail merge was generated, I get the following: { INCLUDEPICTURE c:\\Claims Processing\\App\\scantest2.bmp } This is the right location for the bitmap, but it is not appearing in the document. Any suggestions? What am I not seeing? Thanks, Phill "Peter Jamieson" wrote: How do I insert an Object into a Mail/Merged Word document? Word doesn't have a facility to do this. Your best bet as far as Word is concerned is to store theimages in a format Word can use (.e.g. .jpg, .bmp) in a normal foler in Windows, and store either the filename or pathname in your database in a field called picturefile or picturepath, say. Then in Windows you can use a nested merge field such as { INCLUDEPICTURE "c:\\mypictures\\{ MERGEFIELD picturefile }" } or { INCLUDEPICTURE "{ MERGEFIELD picturepath }" } Use Google groups to find other recent messages containing INCLUDEPICTURE and MERGEFIELD to find more info. on this. In fact there are two ways you can insert your images into Access and neither of them works with Word, but if you are going to store a lot of them in there anyway I suggest you change the way you are doing it. You might want to ask about this in an Access group, but the trouble is that the way you are doing it wraps the image in an OLE wrapper which is specific to the program set up on your machine to handle the type of graphic (.jpg, whatever) you are storing, then (as far as I can remember) inside an Access wrapper). So if for example you move the application to a machine which does not have that application, the images cannot be displayed. Worse, if you are working with (say) Office 2000 and upgrade to Office 2003 you may find that that application is replaced by something which cannot handle the wrapped images. There's another way to store the images by using code to store the unwrapped image in a memo or OLE field. I don't know what the implications of that are for your Access application As far as Word mailmerge is concerned, it does not /really/ help, but it does then become possible to insert the images during a Word 2002/2003 mailmerge by using ADO code in a Mailmerge event handler. Peter Jamieson "SmogerP" wrote in message ... I am utilizing Access97 and Word 2000. I have set up processes in Access that creates a table that I utilize to open Word and create a Mail/Merge document in Word. This process works great! What I am trying to do is to add a field to our User table set up as an Ole Object and add a signature to the field. From there I have scanned the signatures and it all seems to be working fine until I get to WORD. In Word I add the field into the document as a Mail/Merge field and when I run the document, all that comes up is letters and numbers i.e. "1507DC04" This is just a sample. How do I insert an Object into a Mail/Merged Word document? Thanks, Phill |
#4
|
|||
|
|||
Are the {} surroung the INCLUEPICTURE the special field braces you can
insert using ctrl-F9? Ensure that Tools|Options|Print|Update fields and Update Links are checked. If you are merging to a new document, you may also have to select the document (e.g. ctrl-A) and press F9 to update all the fields. Peter Jamieson "SmogerP" wrote in message ... In my Access table I created a text field called Signature, Text (250). In the text field I put the value of "c:\\Claims Processing\\App\\scantest2.bmp". In my word document I put: { INCLUDEPICTURE «Signature» } and when the mail merge was generated, I get the following: { INCLUDEPICTURE c:\\Claims Processing\\App\\scantest2.bmp } This is the right location for the bitmap, but it is not appearing in the document. Any suggestions? What am I not seeing? Thanks, Phill "Peter Jamieson" wrote: How do I insert an Object into a Mail/Merged Word document? Word doesn't have a facility to do this. Your best bet as far as Word is concerned is to store theimages in a format Word can use (.e.g. .jpg, .bmp) in a normal foler in Windows, and store either the filename or pathname in your database in a field called picturefile or picturepath, say. Then in Windows you can use a nested merge field such as { INCLUDEPICTURE "c:\\mypictures\\{ MERGEFIELD picturefile }" } or { INCLUDEPICTURE "{ MERGEFIELD picturepath }" } Use Google groups to find other recent messages containing INCLUDEPICTURE and MERGEFIELD to find more info. on this. In fact there are two ways you can insert your images into Access and neither of them works with Word, but if you are going to store a lot of them in there anyway I suggest you change the way you are doing it. You might want to ask about this in an Access group, but the trouble is that the way you are doing it wraps the image in an OLE wrapper which is specific to the program set up on your machine to handle the type of graphic (.jpg, whatever) you are storing, then (as far as I can remember) inside an Access wrapper). So if for example you move the application to a machine which does not have that application, the images cannot be displayed. Worse, if you are working with (say) Office 2000 and upgrade to Office 2003 you may find that that application is replaced by something which cannot handle the wrapped images. There's another way to store the images by using code to store the unwrapped image in a memo or OLE field. I don't know what the implications of that are for your Access application As far as Word mailmerge is concerned, it does not /really/ help, but it does then become possible to insert the images during a Word 2002/2003 mailmerge by using ADO code in a Mailmerge event handler. Peter Jamieson "SmogerP" wrote in message ... I am utilizing Access97 and Word 2000. I have set up processes in Access that creates a table that I utilize to open Word and create a Mail/Merge document in Word. This process works great! What I am trying to do is to add a field to our User table set up as an Ole Object and add a signature to the field. From there I have scanned the signatures and it all seems to be working fine until I get to WORD. In Word I add the field into the document as a Mail/Merge field and when I run the document, all that comes up is letters and numbers i.e. "1507DC04" This is just a sample. How do I insert an Object into a Mail/Merged Word document? Thanks, Phill |
#5
|
|||
|
|||
They were not the {} from the ctrl-F9, but are now. Here is code:
{ INCLUDEPICTURE "c:\Claims ProcessingApp\scantest2.bmp" } I am able to toggle the field codes, so I am assuming is it accurate. The "c:\..." is where the bitmap is stored. When I close out and run the mail merge process, all I get is an empty picture with the little red "x" at top left. I then did a "Select All" and an "F9" and nothing happened. I checked the Tools/Options/... the two boxes you mention are now checked. Still get the same thing. "Peter Jamieson" wrote: Are the {} surroung the INCLUEPICTURE the special field braces you can insert using ctrl-F9? Ensure that Tools|Options|Print|Update fields and Update Links are checked. If you are merging to a new document, you may also have to select the document (e.g. ctrl-A) and press F9 to update all the fields. Peter Jamieson "SmogerP" wrote in message ... In my Access table I created a text field called Signature, Text (250). In the text field I put the value of "c:\\Claims Processing\\App\\scantest2.bmp". In my word document I put: { INCLUDEPICTURE «Signature» } and when the mail merge was generated, I get the following: { INCLUDEPICTURE c:\\Claims Processing\\App\\scantest2.bmp } This is the right location for the bitmap, but it is not appearing in the document. Any suggestions? What am I not seeing? Thanks, Phill "Peter Jamieson" wrote: How do I insert an Object into a Mail/Merged Word document? Word doesn't have a facility to do this. Your best bet as far as Word is concerned is to store theimages in a format Word can use (.e.g. .jpg, .bmp) in a normal foler in Windows, and store either the filename or pathname in your database in a field called picturefile or picturepath, say. Then in Windows you can use a nested merge field such as { INCLUDEPICTURE "c:\\mypictures\\{ MERGEFIELD picturefile }" } or { INCLUDEPICTURE "{ MERGEFIELD picturepath }" } Use Google groups to find other recent messages containing INCLUDEPICTURE and MERGEFIELD to find more info. on this. In fact there are two ways you can insert your images into Access and neither of them works with Word, but if you are going to store a lot of them in there anyway I suggest you change the way you are doing it. You might want to ask about this in an Access group, but the trouble is that the way you are doing it wraps the image in an OLE wrapper which is specific to the program set up on your machine to handle the type of graphic (.jpg, whatever) you are storing, then (as far as I can remember) inside an Access wrapper). So if for example you move the application to a machine which does not have that application, the images cannot be displayed. Worse, if you are working with (say) Office 2000 and upgrade to Office 2003 you may find that that application is replaced by something which cannot handle the wrapped images. There's another way to store the images by using code to store the unwrapped image in a memo or OLE field. I don't know what the implications of that are for your Access application As far as Word mailmerge is concerned, it does not /really/ help, but it does then become possible to insert the images during a Word 2002/2003 mailmerge by using ADO code in a Mailmerge event handler. Peter Jamieson "SmogerP" wrote in message ... I am utilizing Access97 and Word 2000. I have set up processes in Access that creates a table that I utilize to open Word and create a Mail/Merge document in Word. This process works great! What I am trying to do is to add a field to our User table set up as an Ole Object and add a signature to the field. From there I have scanned the signatures and it all seems to be working fine until I get to WORD. In Word I add the field into the document as a Mail/Merge field and when I run the document, all that comes up is letters and numbers i.e. "1507DC04" This is just a sample. How do I insert an Object into a Mail/Merged Word document? Thanks, Phill |
#6
|
|||
|
|||
{ INCLUDEPICTURE "c:\Claims ProcessingApp\scantest2.bmp" }
The backslashes in this need to be doubled up - they were like that in your previous message! { INCLUDEPICTURE "c:\\Claims ProcessingApp\\scantest2.bmp" } Peter Jamieson "SmogerP" wrote in message ... They were not the {} from the ctrl-F9, but are now. Here is code: { INCLUDEPICTURE "c:\Claims ProcessingApp\scantest2.bmp" } I am able to toggle the field codes, so I am assuming is it accurate. The "c:\..." is where the bitmap is stored. When I close out and run the mail merge process, all I get is an empty picture with the little red "x" at top left. I then did a "Select All" and an "F9" and nothing happened. I checked the Tools/Options/... the two boxes you mention are now checked. Still get the same thing. "Peter Jamieson" wrote: Are the {} surroung the INCLUEPICTURE the special field braces you can insert using ctrl-F9? Ensure that Tools|Options|Print|Update fields and Update Links are checked. If you are merging to a new document, you may also have to select the document (e.g. ctrl-A) and press F9 to update all the fields. Peter Jamieson "SmogerP" wrote in message ... In my Access table I created a text field called Signature, Text (250). In the text field I put the value of "c:\\Claims Processing\\App\\scantest2.bmp". In my word document I put: { INCLUDEPICTURE «Signature» } and when the mail merge was generated, I get the following: { INCLUDEPICTURE c:\\Claims Processing\\App\\scantest2.bmp } This is the right location for the bitmap, but it is not appearing in the document. Any suggestions? What am I not seeing? Thanks, Phill "Peter Jamieson" wrote: How do I insert an Object into a Mail/Merged Word document? Word doesn't have a facility to do this. Your best bet as far as Word is concerned is to store theimages in a format Word can use (.e.g. .jpg, .bmp) in a normal foler in Windows, and store either the filename or pathname in your database in a field called picturefile or picturepath, say. Then in Windows you can use a nested merge field such as { INCLUDEPICTURE "c:\\mypictures\\{ MERGEFIELD picturefile }" } or { INCLUDEPICTURE "{ MERGEFIELD picturepath }" } Use Google groups to find other recent messages containing INCLUDEPICTURE and MERGEFIELD to find more info. on this. In fact there are two ways you can insert your images into Access and neither of them works with Word, but if you are going to store a lot of them in there anyway I suggest you change the way you are doing it. You might want to ask about this in an Access group, but the trouble is that the way you are doing it wraps the image in an OLE wrapper which is specific to the program set up on your machine to handle the type of graphic (.jpg, whatever) you are storing, then (as far as I can remember) inside an Access wrapper). So if for example you move the application to a machine which does not have that application, the images cannot be displayed. Worse, if you are working with (say) Office 2000 and upgrade to Office 2003 you may find that that application is replaced by something which cannot handle the wrapped images. There's another way to store the images by using code to store the unwrapped image in a memo or OLE field. I don't know what the implications of that are for your Access application As far as Word mailmerge is concerned, it does not /really/ help, but it does then become possible to insert the images during a Word 2002/2003 mailmerge by using ADO code in a Mailmerge event handler. Peter Jamieson "SmogerP" wrote in message ... I am utilizing Access97 and Word 2000. I have set up processes in Access that creates a table that I utilize to open Word and create a Mail/Merge document in Word. This process works great! What I am trying to do is to add a field to our User table set up as an Ole Object and add a signature to the field. From there I have scanned the signatures and it all seems to be working fine until I get to WORD. In Word I add the field into the document as a Mail/Merge field and when I run the document, all that comes up is letters and numbers i.e. "1507DC04" This is just a sample. How do I insert an Object into a Mail/Merged Word document? Thanks, Phill |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep two words together? | Microsoft Word Help | |||
letters - ask/fillin | New Users | |||
how to convert wordperfect 5.0 floppy files to word | Microsoft Word Help | |||
Converted document from WordPerfect. New footnotes are not being. | Microsoft Word Help | |||
Blank rectangles when snapshot objects are inserted into word docs | Microsoft Word Help |