Welcome Guest.   Make a donation to an author on the site May 24, 2013, 10:54:46 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 2011! Download 30+ custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
+  DonationCoder.com Forum
|-+  Main Area and Open Discussion
| |-+  General Software Discussion
| | |-+  anything more advanced than mail merge?
Pages: [1]   Go Down
« previous next »
  Reply  |  New Topic  |  Print  
Author Topic: anything more advanced than mail merge?  (Read 1536 times)
kalos
Member
**
Posts: 909

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,554

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: 909

View Profile Give some DonationCredits to this forum member
« Reply #2 on: January 24, 2012, 05:44:49 AM »
Quote from: rjbull on January 23, 2012, 10:39:35 AM
Maybe something like mouser's Form Letter Machine?

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


[ may-june 2013 ad experiment; click here to learn more about donationcoder.com ]

kalos
Member
**
Posts: 909

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: 909

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: 600


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: 909

View Profile Give some DonationCredits to this forum member
« Reply #6 on: January 29, 2012, 02:23:24 PM »
Quote from: AndyM 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.

thanks for the suggestion
if anyone is familiar with vba, can you tell me which commands I need?
thanks
Logged
AndyM
Charter Member
***
Posts: 600


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  
« previous next »



[ may-june 2013 ad experiment; click here to learn more about donationcoder.com ]


 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

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