Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • September 01, 2015, 11:26:23 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: anything more advanced than mail merge?  (Read 2520 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,369
    • View Profile
    • Donate to Member
anything more advanced than mail merge?
« on: January 23, 2012, 02:45:18 AM »
hello

my goal is to fill word document drafts with specific text in specific locations inside the draft

let's say I have draft.a and draft.b and I want to make two draft.a documents (draft.a.1 and draft.a.2) and two draft.b documents (draft.b.1 and draft.b.2), using specific each time text to fill specific locations in each draft

is there a handy way to do this? I am looking something like MS WORD's mail merge, but more advanced (ability to easily use various drafts and not one, ability to easily determine where the text will be placed in each draft, etc)

any idea?

thanks!

rjbull

  • Charter Member
  • Joined in 2005
  • ***
  • default avatar
  • Posts: 2,856
    • View Profile
    • Donate to Member
Re: anything more advanced than mail merge?
« Reply #1 on: January 23, 2012, 10:39:35 AM »
Maybe something like mouser's Form Letter Machine?

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,369
    • View Profile
    • Donate to Member
Re: anything more advanced than mail merge?
« Reply #2 on: January 24, 2012, 05:44:49 AM »
Maybe something like mouser's Form Letter Machine?

it seems interesting, I will check it out, thanks!

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,369
    • View Profile
    • Donate to Member
Re: anything more advanced than mail merge?
« Reply #3 on: January 25, 2012, 04:33:22 AM »
unfortunately I dont think it does what I want

I want to make a text file (or excel) where each line contains the data with which each draft will be completed
Draft1, somefield, somefield, somefield
Draft2, somefield, somefield
Draft2, somefield, somefield, somefield

the first word (draft1 or draft2) will determine which draft will be used as base
the next words will determine the values that will be placed in each filed of the draft

any idea?

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,369
    • View Profile
    • Donate to Member
Re: anything more advanced than mail merge?
« Reply #4 on: January 29, 2012, 09:40:01 AM »
bump

AndyM

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 616
    • View Profile
    • Donate to Member
Re: anything more advanced than mail merge?
« Reply #5 on: January 29, 2012, 12:24:13 PM »
You could try this in Word and/or Excel with a little VBA.

Especially if the only (or mostly the only) thing you need that mailmerge can't do is to pick which draft to use - use vba for that part and then start the mailmerge.  Or just use vba for the whole thing.

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,369
    • View Profile
    • Donate to Member
Re: anything more advanced than mail merge?
« Reply #6 on: January 29, 2012, 02:23:24 PM »
You could try this in Word and/or Excel with a little VBA.

Especially if the only (or mostly the only) thing you need that mailmerge can't do is to pick which draft to use - use vba for that part and then start the mailmerge.  Or just use vba for the whole thing.

thanks for the suggestion
if anyone is familiar with vba, can you tell me which commands I need?
thanks

AndyM

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 616
    • View Profile
    • Donate to Member
Re: anything more advanced than mail merge?
« Reply #7 on: January 29, 2012, 08:02:57 PM »
You could ask over at VBAExpress:

http://www.vbaexpress.com/forum/