Word Table saved as ActiveX in Access, how to display in Word

P

Pejo

I use Word and Access 2007 with a mail-merge OLE DB connection
that works well with the linking of text fields, etc. (type customer and
contact information)
My problem is that I need to link into a formatted Word table stored in data
type, ActiveX, Access to my Word document.
When I try it says only "151C2E00" in the field, where the table would appear

Someone who has solution!


Sub Foto()
ActiveDocument.MailMerge.OpenDataSource Name:= _
"\\vmware-host\Shared Folders\My Documents\Mina datakällor\Foto.
accdb" _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="",
_
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False,
_
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=\\vmware-
host\Shared Folders\My Documents\Mina datakällor\Foto.
accdb;Mode=Read;Extended Properties="""";Jet OLEDB:System database="""";Jet
OLEDB:Registry Path="""";Jet OLEDB:Engine Type=6;Jet OLED" _
, SQLStatement:="SELECT * FROM `FR_Kopplat_Till_Word_25`",
SQLStatement1 _
:="", SubType:=wdMergeSubTypeAccess
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mailmerge recorded macro 0
Word connectivity (continued) 0
VBA Word: Mail merge labels printing 0
Using mailmerge code in Word 2007 5
Mail Merge Programming problem 1
Mailmerge FindEntry problem 0
Mail merge macro from xp to vista 2
Ignore table formatting when importing data using OLEDB 0

Top