SynapseDirect

I still get sometimes.  When it happens I have to close Access and restart it to make it go away.

Oddly. I can just stop the debugger, return to Access, perform the same steps .. and the Word Document is generated fine.

I sometimes get "Blank" Word Documents appear when a Word Document is generated.  Ie. I get the document intended, plus another instance of Word with no document.

Jason:

I still get sometimes.  When it happens I have to close Access and restart it to make it go away.

Oddly. I can just stop the debugger, return to Access, perform the same steps .. and the Word Document is generated fine.

I sometimes get "Blank" Word Documents appear when a Word Document is generated.  Ie. I get the document intended, plus another instance of Word with no document.

I have the same problem.  I'm supposed to put some error handling codes in there.  But I am not a programmer, so I never bothered looking into solving that and making it perfect.

qilin:

Now you can use the same method to populate demographic info to your forms I guess.  You don't even need to create a query for this if all you need is demographics, you can just use the table "USERS".  My patient list view lists all the visits.  You can modify this form, change the datasource of the subform to table "USERS" so it will only list the patients, and modify the mailmerge VBA codes accordingly.

I must be dozing off when writing that.  For your purpose, you absolutely don't need Mail Merge.  Using MS Access's own report is much easier and you won't get those error messages due to my buggy Mail Merge solution.  I use Mail Merge for consult letters because I like to use Word's instant spell check.  Another reason I have to use Office 2003 instead of 2007 is that I have an old verison Stedman's Medical Spellchecker which works with old Office suites but doesn't work for 2007.

qilin,

are you still using MS ACCESS to pull Firebird data ? 

I am thinking about doing my referrals in Word.

I will need to get this going again.

qilin, any tips ?

I only use it occasionally now when the receptionist needs to print a consult that wasn't saved in PDF.

If all you need is a referral form, you may not need Word, you can just create a report in Access and pull the information from the database

I rephrase that.

How are you using Access with Synapse ?

I do want a MS word copy of my referral letter in my "PaperPort directory" for that patient.

I see.  Then you can use exactly the same method we had discussed and follow the steps that I outline in the first post: pull data from the database, use mailmerge to generate a word file and save to your patient folder.

Alternatively, you can use Access report and print out as a PDF file (using PDF factory or acrobat pro) to save in your patient folder, since the mailmerge codes I posted here is still a little buggy and sometimes you need to click more than once to make it work.  This will probably make things easier for you.