Solved

Pulling data into Word using DDE

Posted on 2011-03-24
6
1,137 Views
Last Modified: 2013-11-15
Ive got an application form which Im pulling data from goldmine. Ive been able to populate most of the form since the fields are standard but Ive got an address field which I need to pull three different fields from goldmine which are

UPRPRVADD1
UPRPRVADD2
UPRPRVADD3
UPRPRVPCDE

When I right click on the text box, Ive selected Edit, it allows me to use a formula.

Im trying to create a formula so it pulls all the above fields, my best guess was

=CONTACT2->UPRPRVADD1 & " " & CONTACT2->UPRPRVADD2 & " " & CONTACT2->UPRPRVADD3 & " " & CONTACT2->UPRPRVPCDE

I get syntax error when I insert this.


0
Comment
Question by:daiwhyte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:GMGenius
ID: 35206199
CONTACT2->UPRPRVADD3 is the normal correct forumla, however you dont explain how you are using the DDE

can you provide a test document that shows this.
0
 

Author Comment

by:daiwhyte
ID: 35207130
DDEAUTO GoldMine Data CONTACT2->UA1JBYRS \*CHARFORMAT  \* MERGEFORMAT

The above is how the data is pulled, I got this from selecting Edit Field option. Does that help?
Not able to supply the form, its got sensitive stuff on it, sorry GMG.
0
 
LVL 12

Expert Comment

by:GMGenius
ID: 35207403
The simplest way is to add each field with a space after each

{DDEAUTO GoldMine Data CONTACT2->UPRPRVADD1 \*CHARFORMAT  \* MERGEFORMAT } {DDEAUTO GoldMine Data CONTACT2->UPRPRVADD2 \*CHARFORMAT  \* MERGEFORMAT }  {DDEAUTO GoldMine Data CONTACT2->UPRPRVADD3 \*CHARFORMAT  \* MERGEFORMAT }  {DDEAUTO GoldMine Data CONTACT2->UPRPRVPCDE\*CHARFORMAT  \* MERGEFORMAT } 

Open in new window


You cant easily combine fields inside the { } fields
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

Author Comment

by:daiwhyte
ID: 35240291
When I try to create a formula and insert the above suggestion into the formula, it still gives

!Syntax Error, {
0
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
ID: 35240442
Hi,

You cant put all that in the formula, you have to insert multiple formulas, if you have the GoldMine word addin loaded you can just choose, Insert field, choose any field to start , then you can edit it

Right click on the inserted field and select , "Toggle field codes" to allow you to see it. then you can edit the fields and change it for example.

if you insert the company field you will see
{DDEAUTO GoldMine Data &Company \*CHARFORMAT  \* MERGEFORMAT }

Change this too
{DDEAUTO GoldMine Data CONTACT2->UPRPRVADD1\*CHARFORMAT  \* MERGEFORMAT }

then copy the field and paste, then edit the next one. and so on.

0
 

Author Closing Comment

by:daiwhyte
ID: 35374007
Ok, after a bit of fiddling about, Ive got it working. thank you GMG
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question