+ Reply to Thread
Results 1 to 2 of 2

Kinda Urgent Mail Merge Macro Access 2013

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    18

    Kinda Urgent Mail Merge Macro Access 2013

    Hi Team,

    I am attempting to use Access to preform a mail merge using a query that has been exported to csv and the mail merge in word is all set up all we need to do is physically run the mail merge.

    I have used the following code however it just opens that document but does not update the merge information... Your assistance is appreciated...

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,744

    Re: Kinda Urgent Mail Merge Macro Access 2013

    Why not either:
    1. Create the template in Access and run a mail merge directly in Access with the Query as the record source?
    or
    2. Use the mailmerge wizard in Word for the template and the query again as the record source for the variables?

    Why the extra steps with the CSV file and the VBA to run it when there is built in functionality to do this?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. mail merge (?) on certain rows of sheet with access records included too?
    By jontom in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-13-2013, 08:07 AM
  2. Macro to mail merge
    By aathar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2013, 11:42 AM
  3. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  4. This is kinda urgent. Need help with matrix stuff.
    By Betts in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2006, 12:01 PM
  5. Replies: 0
    Last Post: 01-03-2006, 02:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1