Mail merging programmatically (1 Viewer)

[Charlie]

Dear Accessers,

I'm trying to merge the names and addresses of customers out to word. I decided that I'd use a query and then use a button to call the merge wizard. The trouble is I don't know how to do it programmatically.

Another small thing is, how do I do a carriage return?? I've tried | |, Chr(10) and chr(13). I'm running Ms Access '97 and I can't find it in help.

Thanks for your time,

Charlie

 

[Axis]

I'm not sure if there is direct function that calls the Merge Wizard, but you should be able to use DoMenuItem to pull it off. Look it up in Help.

For the second part, Access wants a carriage return AND a line feed to create line breaks. Try
[First Field] & Chr(13) & Chr(10) & [Second Field] etc.