Output to a Word Mail Merge

[henp]

Hi,

I need to import a .csv file into Access and then automate a process whereby it would print a letter from a mail merge within Word. I realise I would have to import the .csv file and that there is no way to automate the process, but would like it if that was all I had to do.

Can anyone give me some pointers an how to write the query needed to do this?

Thanks,

Kirsten.

 

[KenReay]

Hi

You may not need to import the csv, have you tried linking to it as if it was a table?, see File \ get external data\ Link on menu


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[henp]

Hey Ken,


Cannot link to a .txt file don't know why states that microsoft jet engine could not find the object. I can do a cut and paste ok. I'm actually more interested in the query to export to mail merge in Word.

Thanks for answering,

Kirsten.

 

[cottontop]

Why export it into Word.


Create a report with a format the same as the letter.

1. import the CSV.
2. Print the report.

Will that work?

 

[henp]

Yes,

Thank You. Is there any way to automate this to print on a certain date and time?

Kirsten.