Results 1 to 7 of 7
  1. #1
    abc123 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2010
    Posts
    4

    Need help with macro

    I have a problem. I have a list in excel of for our company database that includes different companies that we work with and the individuals associated with each company. In order to update our database I need to send a document to each company with a. instructions for verifying information on top. b. company information. c. individual information. I was wondering how do I set up a macro (if that is the solution) that will automatically create tables for each individual in the excel list as well as only rewrite the instructions and company tables when a different company name is encountered. Your help is greatly appreciated.

  2. #2
    Datagopherdan is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Dec 2008
    Posts
    220
    Creating a table for each unique entry wouldn't be too difficult. Let's make sure that's the route to take first though. Do you just need to send e-mails to each name in the list?

  3. #3
    abc123 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2010
    Posts
    4

    figured part of it out

    i figured out how to create the tables by just completing the mail merger. the only thing i dont know is how to make the document start on a new page every time a different company name is introduced. meaning a soft page break

  4. #4
    Datagopherdan is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Dec 2008
    Posts
    220
    Are you saying that you're creating separate tables for each record? That's what I'm trying to find out. You might be doing alot of unnecessary work, which is going to make the merge much more difficult then it needs to be.

  5. #5
    abc123 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2010
    Posts
    4
    yes there is a table for each record. once i complete the merger word duplicates the tables for each record. i just want to know how to make the document page break between companies

  6. #6
    kimmer is offline Competent Performer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    100
    This is a Microsoft Access forum. When you say table, we assume you are talking about an object that stores records in a database. But if Word is making them, then I think you are talking about doing a mail merge in Word using Excel... Nothing at all do with Microsoft Access. Is that correct?

  7. #7
    abc123 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2010
    Posts
    4

    shwoopsies

    yeah my bad didn't realize i placed it in the wrong area

Please reply to this thread with any new information or opinions.

Similar Threads

  1. MACRO help please
    By DianeG in forum Forms
    Replies: 2
    Last Post: 04-20-2010, 07:19 AM
  2. Get Function to run as a macro
    By randolphoralph in forum Programming
    Replies: 11
    Last Post: 01-24-2010, 12:30 AM
  3. import using Macro
    By johnny1g in forum Import/Export Data
    Replies: 1
    Last Post: 09-15-2009, 04:21 AM
  4. Access Macro
    By Gargen in forum Access
    Replies: 0
    Last Post: 09-14-2009, 09:13 AM
  5. error in macro
    By nawaray in forum Access
    Replies: 0
    Last Post: 02-10-2009, 12:06 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums