Welcome Guest.   Make a donation to an author on the site April 19, 2014, 10:14:31 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2012! Download dozens of custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: anything more advanced than mail merge?  (Read 1894 times)
kalos
Member
**
Posts: 977

View Profile Give some DonationCredits to this forum member
« 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!
Logged
rjbull
Charter Member
***
Posts: 2,701

View Profile Give some DonationCredits to this forum member
« Reply #1 on: January 23, 2012, 10:39:35 AM »

Maybe something like mouser's Form Letter Machine?
Logged
kalos
Member
**
Posts: 977

View Profile Give some DonationCredits to this forum member
« 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!
Logged
kalos
Member
**
Posts: 977

View Profile Give some DonationCredits to this forum member
« 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?
Logged
kalos
Member
**
Posts: 977

View Profile Give some DonationCredits to this forum member
« Reply #4 on: January 29, 2012, 09:40:01 AM »

bump
Logged
AndyM
Charter Member
***
Posts: 615


see users location on a map View Profile Give some DonationCredits to this forum member
« 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.
Logged
kalos
Member
**
Posts: 977

View Profile Give some DonationCredits to this forum member
« 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
Logged
AndyM
Charter Member
***
Posts: 615


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #7 on: January 29, 2012, 08:02:57 PM »

You could ask over at VBAExpress:

http://www.vbaexpress.com/forum/
Logged
Pages: [1]   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.025s | Server load: 0.28 ]