Thread: [Solved] MailMerge with excel DDE is not retuning all of the columns
View Single Post
 
Old 04-21-2011, 02:18 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Dale,

Assuming your worksheet has a 'heading row' containing the field names for each:
a. What is the name of the field you're looking for?
b. Are the names of the columns immediately to the left and right of the
column you want shown?
c. do any of the column names hve double-quotes in them?

What happens if you insert the mergefield manually (ie press Ctrl-F9 to create an empty field '{}', then fill the field in with {MERGEFIELD MyData}, where 'MyData' is your data field's name)? Do the data show up when you execute the merge?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote