Thread Tools Display Modes
  #1   Report Post  
Jenn68 Jenn68 is offline
Junior Member
Posts: 4
Default Thoughts on Mail Merge Automation

I am developing a user friendly application utilizing Excel VBA to create and process a database to be used as the source of data for a Word mail merge.

From Excel, the user may choose to create one of 16 different documents based on the data in the database. The 16 different documents are based on the recipient lists of the particular merge.

Currently, all I can automate is Excel opening the appropriate mail merge document. To make the process of finalizing the directory style mail merge document hands off for the user, is it possible that upon opening of the document ...

a) the new document is compiled based on the recipient factors associated with the mail merge document
b) tagged with a unique file name
c) saved
d) printed
e) word closed and returned to Excel


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Automation Code problem Peter Hibbs[_2_] Mailmerge 2 August 25th 09 08:13 PM
Failing Mail Merge Automation Frank[_4_] Mailmerge 1 June 18th 08 08:59 PM
Mail Merge Automation: Call rejeted by Callee KCT Microsoft Word Help 0 December 19th 07 11:39 AM
My merge field is being cut off in my word doc - any thoughts???? Delta G Mailmerge 4 January 26th 07 07:10 PM
Header / Footer mail merge issue with custom built word automation solution. eJimmi Mailmerge 4 July 18th 06 02:48 PM

All times are GMT +1. The time now is 04:54 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"