Dlookup on mail merge Tony Williams 10/4/2008 9:19:01 AM I have a mail merge letter that is linked to an Access database table. I can map most fields that I need but some of the fields I want would be DLookup fields if I was creating an Access report. How do I do DLookup formulas in a Word document? Thanks Tony

RE: Dlookup on mail merge Tony Williams 10/4/2008 9:52:00 AM having Googled my question I've come up with this but it doesn't work I get #Error =DLookUp("[txtmemnumber]","[tblindividual]","[txtsurname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(1)] & [txtfirstname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(2)]") "Tony Williams" wrote: [Quoted Text] > I have a mail merge letter that is linked to an Access database table. I can > map most fields that I need but some of the fields I want would be DLookup > fields if I was creating an Access report. How do I do DLookup formulas in a > Word document? > Thanks > Tony

RE: Dlookup on mail merge Tony Williams 10/4/2008 10:33:01 AM Sorry this was the wrong post it was meant for another Group! I still have the problem! Thanks Tony "Tony Williams" wrote: [Quoted Text] > having Googled my question I've come up with this but it doesn't work I get > #Error > > =DLookUp("[txtmemnumber]","[tblindividual]","[txtsurname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(1)] > & > [txtfirstname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(2)]") > > "Tony Williams" wrote: > > > I have a mail merge letter that is linked to an Access database table. I can > > map most fields that I need but some of the fields I want would be DLookup > > fields if I was creating an Access report. How do I do DLookup formulas in a > > Word document? > > Thanks > > Tony

Re: Dlookup on mail merge "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/4/2008 7:40:45 PM Use a query in Access as the data source. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Tony Williams" <TonyWilliams[ at ]discussions.microsoft.com> wrote in message news:4FBEBBE5-A278-4C21-9823-5B0B1D029EB4[ at ]microsoft.com... [Quoted Text] >I have a mail merge letter that is linked to an Access database table. I >can > map most fields that I need but some of the fields I want would be DLookup > fields if I was creating an Access report. How do I do DLookup formulas in > a > Word document? > Thanks > Tony