Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-12-2013, 05:27 AM   #1
GiPSyFiSH
Newly Registered User
 
Join Date: Jul 2013
Posts: 5
Thanks: 1
Thanked 1 Time in 1 Post
GiPSyFiSH is on a distinguished road
Wink Sharing my mail merge system

Hey

I had posted a question earlier about changing Albert Kallal's Mail Merge code to allow foreign characters (instead of them showing up as ?????? after the merge)

Nobody replied so I started building my own system from scratch.

An example database is included for those interested.

It's not perfect yet, as it doesn't create directories (folders) where they do not exist yet, but that's easy to iron out.

What it does is, with the call of 1 function on a button, export any sql you pass based on any table or query and export it to word (rtf).

Then it opens a dialogue window where you can pick your template and perform the merge based on that rtf file (or edit your templates).

BEWARE:
1. Ignore the comments in the code, some are no longer relevant. Needs cleaning.
2. Directory name of the templates is based on the source query or table, at the moment it doesn't create new folders well.
3. The naming of the variables isn't always the best

The included example database should work though, given you leave the directory structure intact.

Just sharing,might be helpful to someone, never know, if interested, I can upload a polished version when completely finished.

Cheers

PeopleWordMerge.zip

GiPSyFiSH is offline   Reply With Quote
Reply

Tags
export , kallal , mail merge , word

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
E-mail/ mail merge/ automation. Almost there...?! mattkorguk Modules & VBA 9 05-29-2008 11:27 PM
Database Password stopping mail merge and catalog merge???!??! sgtblitz General 1 04-17-2008 10:46 AM
[SOLVED] I need to merge an OLE field containing word docs into a word mail merge fearless_freep Modules & VBA 1 03-16-2007 02:57 AM
Mail Merge E-mail body iazcac Forms 0 01-11-2005 10:35 AM
[SOLVED] Sharing a Database System on a Network koulthard General 1 11-13-2002 01:36 AM




All times are GMT -8. The time now is 06:51 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World