Using VBA to merge complex data

From: JBob (x)
Date: 02/27/05


Date: Sun, 27 Feb 2005 09:08:22 -0600

I have a Word XP document with merge codes (converted from WP). The data
source is several tables from my database. Rather than construct a complex
query to get all of the data into a single table to use as my merge data
source, I want to use VBA to populate the document. How can I identify the
Mergefields in code to achieve this?



Relevant Pages

  • RE: Build A User Defined STR Statement Using Access 2000
    ... few codes to check, I will use the text field method. ... I have taken an extract from a query which I currently use to find specific ... I would like a variable to buld up a resulting STR ... I then want the database to automatically build a query with the STR ...
    (microsoft.public.access.modulesdaovba)
  • Re: Only displaying the form window
    ... This database has a startup ... I was puting the codes ... > startup form and just use the main switchboard, ... I don't have Access 2003 installed, but if its version of the Northwind ...
    (microsoft.public.access.forms)
  • Re: Comparing contents of two spreadsheets and outputting results to a
    ... is in Sheet1, zip codes in col A from row2 down ... > I have the following - a large contact database is XLS format with address ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Database set up help
    ... I suspect a detailed revision of the database design is beyond the scope of a newsgroup discussion at this point. ... my bosses wanted me to add Security Options to the picture. ... for say the user picked the ACP application code out of the 20 choices ... Like I stated earlier there are 20 application codes and each one has ...
    (microsoft.public.access.gettingstarted)
  • radius search
    ... The hard part is your database, which will need to include lat/lon ... you're looking for US zip codes, of course...most countries use a term ... Google Maps Javascript API to do the initial lat/lon calculations, ...
    (microsoft.public.dotnet.languages.csharp)