If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining DDE Expressions
I use GoldMine's (CRM Software) link with Microsoft Word to merge documents.
GoldMine uses DDE to feed data from its database to Word. Here's an example of a GoldMine DDE command that I can plug in to MS Word: {DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}. At the same time, I use some of Word's own merge commands to insert images as a dynamic link. Here's an example: {INCLUDEPICTURE "../../../Sigs/ADEMAR.BMP" \* MERGEFORMAT \d} In this case, I'm merging a picture called "ADEMAR.BMP". What I need to accomplish is have the picture file name be dynamic. I need the filename to be feed through to Word from GoldMine's DDE command shown above. I tried nesting GoldMine's DDE command into Word's DDE command but it didn't work. It seems that Word is using whatever GoldMine feeds at the time I inserted the DDE command and saved the document as a template. Therefore, it always links the picture that was used when I first created/saved the template. I have successfully combined GoldMine's DDE Commands with Word's DDE Commands in the past but I have not had any luck with this one. I've tried several variations of the following: {INCLUDEPICTURE "../../../Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}.BMP" \* MERGEFORMAT \d} Any ideas? Thanks! Ademar. |
#2
|
|||
|
|||
Combining DDE Expressions
Hi Ademar,
A couple of points: 1. The path for an INCLUDEPICTURE field needs to be fully spelt out, including the drive letter. AFAIK, you can't use network paths. 2. The \*CHARFORMAT and \* MERGEFORMAT switches are superfluous Try something like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} An alternative approach might be to use the DDEAUTO field to create a bookmark and use that in the INCLUDEPICTURE field: {SET PicName {DDEAUTO GoldMine Data CONTACT2-UACCTMGR}} and {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{PicName}.BMP" \d} Also, if the DDEAUTO field includes a path or filename extension, you should delete them from the rest of the INCLUDEPICTUREfield. Cheers PS: INCLUDEPICTURE fields and the like normally use double back-slashes (i.e. '\\') as path separators, but single forward-slashes, as shown above, work just as well. "Ademar" wrote in message ... I use GoldMine's (CRM Software) link with Microsoft Word to merge documents. GoldMine uses DDE to feed data from its database to Word. Here's an example of a GoldMine DDE command that I can plug in to MS Word: {DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}. At the same time, I use some of Word's own merge commands to insert images as a dynamic link. Here's an example: {INCLUDEPICTURE "../../../Sigs/ADEMAR.BMP" \* MERGEFORMAT \d} In this case, I'm merging a picture called "ADEMAR.BMP". What I need to accomplish is have the picture file name be dynamic. I need the filename to be feed through to Word from GoldMine's DDE command shown above. I tried nesting GoldMine's DDE command into Word's DDE command but it didn't work. It seems that Word is using whatever GoldMine feeds at the time I inserted the DDE command and saved the document as a template. Therefore, it always links the picture that was used when I first created/saved the template. I have successfully combined GoldMine's DDE Commands with Word's DDE Commands in the past but I have not had any luck with this one. I've tried several variations of the following: {INCLUDEPICTURE "../../../Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}.BMP" \* MERGEFORMAT \d} Any ideas? Thanks! Ademar. |
#3
|
|||
|
|||
Combining DDE Expressions
Very educational.
But I still can't get it to work. I tried your first one: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} This one gave me the same problem I was having before. When creating the template, I update/toggle the DDEAUTO GoldMine expression and it plugs in the correct value in its place. Then I update/toggle the INCLUDEPICTUR expression and it merges the correct image. But then after I save the template and do a merge, it merges the wrong image. It basically reverts back to the image that I originally pointed it to. Then I tried the SET PicName. First, I'm not sure I did it right. How do I plug in the {PicName} field without typing it in. It doesn't look like I can just type it in because then the { } don't look valid. Also, are you sure you have the { } positioned correctly because the way you have them it would make the "and" be outside the shaded area. Thanks! "macropod" wrote in message ... Hi Ademar, A couple of points: 1. The path for an INCLUDEPICTURE field needs to be fully spelt out, including the drive letter. AFAIK, you can't use network paths. 2. The \*CHARFORMAT and \* MERGEFORMAT switches are superfluous Try something like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} An alternative approach might be to use the DDEAUTO field to create a bookmark and use that in the INCLUDEPICTURE field: {SET PicName {DDEAUTO GoldMine Data CONTACT2-UACCTMGR}} and {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{PicName}.BMP" \d} Also, if the DDEAUTO field includes a path or filename extension, you should delete them from the rest of the INCLUDEPICTUREfield. Cheers PS: INCLUDEPICTURE fields and the like normally use double back-slashes (i.e. '\\') as path separators, but single forward-slashes, as shown above, work just as well. "Ademar" wrote in message ... I use GoldMine's (CRM Software) link with Microsoft Word to merge documents. GoldMine uses DDE to feed data from its database to Word. Here's an example of a GoldMine DDE command that I can plug in to MS Word: {DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}. At the same time, I use some of Word's own merge commands to insert images as a dynamic link. Here's an example: {INCLUDEPICTURE "../../../Sigs/ADEMAR.BMP" \* MERGEFORMAT \d} In this case, I'm merging a picture called "ADEMAR.BMP". What I need to accomplish is have the picture file name be dynamic. I need the filename to be feed through to Word from GoldMine's DDE command shown above. I tried nesting GoldMine's DDE command into Word's DDE command but it didn't work. It seems that Word is using whatever GoldMine feeds at the time I inserted the DDE command and saved the document as a template. Therefore, it always links the picture that was used when I first created/saved the template. I have successfully combined GoldMine's DDE Commands with Word's DDE Commands in the past but I have not had any luck with this one. I've tried several variations of the following: {INCLUDEPICTURE "../../../Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}.BMP" \* MERGEFORMAT \d} Any ideas? Thanks! Ademar. |
#4
|
|||
|
|||
Combining DDE Expressions
Hi Ademar,
To insert the 'Picname' field, prepare your INCLUDEPICTURE like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/PicName.BMP" \d} Then select 'Picname' and press Ctrl-F9 to turn it into a field. Cheers "Ademar" wrote in message ... Very educational. But I still can't get it to work. I tried your first one: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} This one gave me the same problem I was having before. When creating the template, I update/toggle the DDEAUTO GoldMine expression and it plugs in the correct value in its place. Then I update/toggle the INCLUDEPICTUR expression and it merges the correct image. But then after I save the template and do a merge, it merges the wrong image. It basically reverts back to the image that I originally pointed it to. Then I tried the SET PicName. First, I'm not sure I did it right. How do I plug in the {PicName} field without typing it in. It doesn't look like I can just type it in because then the { } don't look valid. Also, are you sure you have the { } positioned correctly because the way you have them it would make the "and" be outside the shaded area. Thanks! "macropod" wrote in message ... Hi Ademar, A couple of points: 1. The path for an INCLUDEPICTURE field needs to be fully spelt out, including the drive letter. AFAIK, you can't use network paths. 2. The \*CHARFORMAT and \* MERGEFORMAT switches are superfluous Try something like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} An alternative approach might be to use the DDEAUTO field to create a bookmark and use that in the INCLUDEPICTURE field: {SET PicName {DDEAUTO GoldMine Data CONTACT2-UACCTMGR}} and {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{PicName}.BMP" \d} Also, if the DDEAUTO field includes a path or filename extension, you should delete them from the rest of the INCLUDEPICTUREfield. Cheers PS: INCLUDEPICTURE fields and the like normally use double back-slashes (i.e. '\\') as path separators, but single forward-slashes, as shown above, work just as well. "Ademar" wrote in message ... I use GoldMine's (CRM Software) link with Microsoft Word to merge documents. GoldMine uses DDE to feed data from its database to Word. Here's an example of a GoldMine DDE command that I can plug in to MS Word: {DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}. At the same time, I use some of Word's own merge commands to insert images as a dynamic link. Here's an example: {INCLUDEPICTURE "../../../Sigs/ADEMAR.BMP" \* MERGEFORMAT \d} In this case, I'm merging a picture called "ADEMAR.BMP". What I need to accomplish is have the picture file name be dynamic. I need the filename to be feed through to Word from GoldMine's DDE command shown above. I tried nesting GoldMine's DDE command into Word's DDE command but it didn't work. It seems that Word is using whatever GoldMine feeds at the time I inserted the DDE command and saved the document as a template. Therefore, it always links the picture that was used when I first created/saved the template. I have successfully combined GoldMine's DDE Commands with Word's DDE Commands in the past but I have not had any luck with this one. I've tried several variations of the following: {INCLUDEPICTURE "../../../Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}.BMP" \* MERGEFORMAT \d} Any ideas? Thanks! Ademar. |
#5
|
|||
|
|||
Combining DDE Expressions
Ok, got that.
I've tried several different variations but still not working. Any more ideas? Thanks! "macropod" wrote in message ... Hi Ademar, To insert the 'Picname' field, prepare your INCLUDEPICTURE like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/PicName.BMP" \d} Then select 'Picname' and press Ctrl-F9 to turn it into a field. Cheers "Ademar" wrote in message ... Very educational. But I still can't get it to work. I tried your first one: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} This one gave me the same problem I was having before. When creating the template, I update/toggle the DDEAUTO GoldMine expression and it plugs in the correct value in its place. Then I update/toggle the INCLUDEPICTUR expression and it merges the correct image. But then after I save the template and do a merge, it merges the wrong image. It basically reverts back to the image that I originally pointed it to. Then I tried the SET PicName. First, I'm not sure I did it right. How do I plug in the {PicName} field without typing it in. It doesn't look like I can just type it in because then the { } don't look valid. Also, are you sure you have the { } positioned correctly because the way you have them it would make the "and" be outside the shaded area. Thanks! "macropod" wrote in message ... Hi Ademar, A couple of points: 1. The path for an INCLUDEPICTURE field needs to be fully spelt out, including the drive letter. AFAIK, you can't use network paths. 2. The \*CHARFORMAT and \* MERGEFORMAT switches are superfluous Try something like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} An alternative approach might be to use the DDEAUTO field to create a bookmark and use that in the INCLUDEPICTURE field: {SET PicName {DDEAUTO GoldMine Data CONTACT2-UACCTMGR}} and {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{PicName}.BMP" \d} Also, if the DDEAUTO field includes a path or filename extension, you should delete them from the rest of the INCLUDEPICTUREfield. Cheers PS: INCLUDEPICTURE fields and the like normally use double back-slashes (i.e. '\\') as path separators, but single forward-slashes, as shown above, work just as well. "Ademar" wrote in message ... I use GoldMine's (CRM Software) link with Microsoft Word to merge documents. GoldMine uses DDE to feed data from its database to Word. Here's an example of a GoldMine DDE command that I can plug in to MS Word: {DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}. At the same time, I use some of Word's own merge commands to insert images as a dynamic link. Here's an example: {INCLUDEPICTURE "../../../Sigs/ADEMAR.BMP" \* MERGEFORMAT \d} In this case, I'm merging a picture called "ADEMAR.BMP". What I need to accomplish is have the picture file name be dynamic. I need the filename to be feed through to Word from GoldMine's DDE command shown above. I tried nesting GoldMine's DDE command into Word's DDE command but it didn't work. It seems that Word is using whatever GoldMine feeds at the time I inserted the DDE command and saved the document as a template. Therefore, it always links the picture that was used when I first created/saved the template. I have successfully combined GoldMine's DDE Commands with Word's DDE Commands in the past but I have not had any luck with this one. I've tried several variations of the following: {INCLUDEPICTURE "../../../Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}.BMP" \* MERGEFORMAT \d} Any ideas? Thanks! Ademar. |
#6
|
|||
|
|||
Combining DDE Expressions
I did some more troubleshooting and it appears that GoldMine is feeding the
name of the currently logged in user as the filename. I basically doesn't care what we put in the field, it always overrides it. That sucks. -- Regards, Ademar Nunes "Ademar" wrote in message ... Ok, got that. I've tried several different variations but still not working. Any more ideas? Thanks! "macropod" wrote in message ... Hi Ademar, To insert the 'Picname' field, prepare your INCLUDEPICTURE like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/PicName.BMP" \d} Then select 'Picname' and press Ctrl-F9 to turn it into a field. Cheers "Ademar" wrote in message ... Very educational. But I still can't get it to work. I tried your first one: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} This one gave me the same problem I was having before. When creating the template, I update/toggle the DDEAUTO GoldMine expression and it plugs in the correct value in its place. Then I update/toggle the INCLUDEPICTUR expression and it merges the correct image. But then after I save the template and do a merge, it merges the wrong image. It basically reverts back to the image that I originally pointed it to. Then I tried the SET PicName. First, I'm not sure I did it right. How do I plug in the {PicName} field without typing it in. It doesn't look like I can just type it in because then the { } don't look valid. Also, are you sure you have the { } positioned correctly because the way you have them it would make the "and" be outside the shaded area. Thanks! "macropod" wrote in message ... Hi Ademar, A couple of points: 1. The path for an INCLUDEPICTURE field needs to be fully spelt out, including the drive letter. AFAIK, you can't use network paths. 2. The \*CHARFORMAT and \* MERGEFORMAT switches are superfluous Try something like: {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR}.BMP" \d} An alternative approach might be to use the DDEAUTO field to create a bookmark and use that in the INCLUDEPICTURE field: {SET PicName {DDEAUTO GoldMine Data CONTACT2-UACCTMGR}} and {INCLUDEPICTURE "C:/My Documents/PicPath/Sigs/{PicName}.BMP" \d} Also, if the DDEAUTO field includes a path or filename extension, you should delete them from the rest of the INCLUDEPICTUREfield. Cheers PS: INCLUDEPICTURE fields and the like normally use double back-slashes (i.e. '\\') as path separators, but single forward-slashes, as shown above, work just as well. "Ademar" wrote in message ... I use GoldMine's (CRM Software) link with Microsoft Word to merge documents. GoldMine uses DDE to feed data from its database to Word. Here's an example of a GoldMine DDE command that I can plug in to MS Word: {DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}. At the same time, I use some of Word's own merge commands to insert images as a dynamic link. Here's an example: {INCLUDEPICTURE "../../../Sigs/ADEMAR.BMP" \* MERGEFORMAT \d} In this case, I'm merging a picture called "ADEMAR.BMP". What I need to accomplish is have the picture file name be dynamic. I need the filename to be feed through to Word from GoldMine's DDE command shown above. I tried nesting GoldMine's DDE command into Word's DDE command but it didn't work. It seems that Word is using whatever GoldMine feeds at the time I inserted the DDE command and saved the document as a template. Therefore, it always links the picture that was used when I first created/saved the template. I have successfully combined GoldMine's DDE Commands with Word's DDE Commands in the past but I have not had any luck with this one. I've tried several variations of the following: {INCLUDEPICTURE "../../../Sigs/{DDEAUTO GoldMine Data CONTACT2-UACCTMGR \*CHARFORMAT}.BMP" \* MERGEFORMAT \d} Any ideas? Thanks! Ademar. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Function isn't available in expressions in query expressions - hel | Icmeler | General Discussion | 3 | January 30th, 2008 09:33 PM |
Expression Builder Missing Expressions | AndreiK | Database Design | 2 | February 11th, 2005 05:33 PM |
Combining expressions | Bill Davis | Running & Setting Up Queries | 3 | September 16th, 2004 12:49 PM |
Function isn't available in expressions in query expression | Derek Ruesch | General Discussion | 1 | July 14th, 2004 11:52 PM |
Combining Multiple Address Lists and Deleting Duplicates | wgolli | Worksheet Functions | 2 | June 6th, 2004 02:27 AM |