Mail Merge

[rajeshsarin]

Folks,

What is the best way to trigger a mail merge from access to word.

I have a client database, and when a user is looking at a particular record, I wish to give them the option to click a button that will create a standard mailmerge doc for that particular client only.

Regards

 

[HiTechCoach]

You can add this to your database to do what you need:

Super Easy Word Merge

Hope this helps...

 

[rajeshsarin]

Thanks for the link, works great.

However the application doesnt pickup the data from the subform, it only picks up data which is related to the main form (main table).

Regards

 

[dbDamo]

Create hidden controls on your main form that refer to the controls on your subform

 

[rajeshsarin]

how do I do that? any Clues?

 

[dbDamo]

1. Create a new text field in your form
2. Rename the label for the text box to be the name of your sub form field
3. Enter the following into your text box while still in design view:-

=[YourSubFormNameHere].Form![YourSubForm'sControlNameHere]

4. Repeat steps 1-3 for each control you need to refer to

 

[GaryPanic]

I don't think that this will help

my solution to this was

create a temp table and use append and delete qry to populate the table then put all the fields form this temp table on the form (properties visible - no)

this gives you upto 250 fields to play with

 

[dbDamo]

Why do you think it won't help?

 

[GaryPanic]

if it works great .. but I messed around with this and it didn't seem to like it (It wanted to be tied to the underlying table and you could not link two tables together )

 

[rajeshsarin]

=[YourSubFormNameHere].Form![YourSubForm'sControlNameHere]

I have changed this to:-

= [Contract].Form![Contract_ID]

But it doesnt seem to work, can you shed some more light on "![YourSubForm'sControlNameHere]"

Regards

 

[dbDamo]

When you say it doesn't work, do you mean you are unable to reference the field or you are unable to use the new field for your merge?

 

[rajeshsarin]

I am unable to reference the field, and hence it doesnt appear in my merge options.

 

[rajeshsarin]

What exactly should be contianed in Form!SubFormControlName

 

[dbDamo]

Can you upload a copy of your database. I will add one of the subforms controls to your main form for you and you can then repeat this for any remaining controls.

 

[rajeshsarin]

Here you go mate

http://www.4shared.com/file/136716561/c5995a5/MigrationGuru.html

 

[dbDamo]

I cant access file hosting sites from work mate. Can you just zip it up and upload it here?

 

[dbDamo]

I have added the assessing body control from your skills subform to your main form in the database attached in this link -
http://www.4shared.com/file/136810434/d4bb1251/migrationguru.html

This should give you an idea of how it is done. All you need to do is repeat this for all subform controls required and set their visible properties to no.

BTW, there are a couple of reasons you are having difficulty adding the contract_id control:-

a) your subform's name isn't contract, it is child104 - you should change this

b) there is no contact_id control in this subform

 

[rajeshsarin]

Reply: Mail Merge

Works very well............thanks.

can you also advise the best possible way to make this mail merge work in a multi user environment.

I basically have a file server, and about 8 clients in a workgroup, who access this database in shared mode.........so I want everone to have the facility to mail merge.........

Regards

 

[dbDamo]

Have you split your Database and given each user a separate Front End?

Obviously this would be the most efficient way as the processing takes place on each users Front End, rather than everyones processing taking place on your server.

This also offers more protection against corruption, improves performance and if one users Front End corrupts, the others are not affected and you can simply give the user a new copy of the Front End.