letter feeding from DB

[IOI]

having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it?

cheers

 

[zaqyu]

Can you be more specific on your question. Do you want to have a button to print an Access Report (your letter) that will contain the Info or do you want a button that mail merges your info into a Word Doc?

 

[boblarson]

I think you might want a Word Mail merge:

http://office.microsoft.com/en-us/help/HA010349201033.aspx

 

[IOI]

I work in college. I do have a table full of names and course names etc. We send offer letters to applicants. I need a letter that feeds from specific record of the table. Not hundreds of letters. One out of the time.

ps we've got novell network with win xp, anyone has to be able to access database and print the letter

So is it possible to create word mail merge that feeds from network access database?

cheers

 

[IOI]

I Created mail merged letter feeding from my database. Thank you for help.

Now, how to open this .doc file from access? Is it doable?

 

[boblarson]

I Created mail merged letter feeding from my database. Thank you for help.

Now, how to open this .doc file from access? Is it doable?

Yes, do you just need to open it? If so, a quick easy way is:

FollowHyperlink "PutYourPathTotheDocumentHere.doc"

 

[IOI]

Yes, do you just need to open it? If so, a quick easy way is:

FollowHyperlink "PutYourPathTotheDocumentHere.doc"

nice...how to do the button that doesn't show the full link though, the name of the letter in this case instead?

 

[boblarson]

In design mode, select the button's CAPTION property and modify it.

 

[IOI]

In design mode, select the button's CAPTION property and modify it.

thank you, Bob...it seems I got where I wanted

 

[IOI]

thank you, Bob...it seems I got where I wanted

almost there...

it works, however when opening word file from access hyperlink it says that it can be harmful to my computer, then confirming data link properties...

lots of clicking to get there...how to get rid of this security message?