Hi JennEx,
The reason for no SQL prompt in the document and no mailmerge is because it's no longer connected to the data source. So, yes, you'd need to re-connect that one to do a manual mailmerge.
Quote:
|
I was required to disable the SQL warning through a registry change as recommended by Microsoft.
|
I don't linke messing around with the registry, as doing so affects more than just the documents of interest - it'd affect other mailmerges too. With the vba code I posted, you don't need the registry edits anyway.
Regarding the setp-through, it's frustrating that one document still generates decimal values for you. I don't really understand why. That could be overcome via a field code change or a change to the connection method (eg to DDE), but really neither should be necessary. The field code to turn a decimal value to a time is:
{QUOTE
{SET ss{=ROUND({MERGEFIELD Time}*86400,0)}}
{SET hr{=INT(ss/3600) \# 0}}
{SET mn{=INT((ss-hr*3600)/60) \# 0}}
{SET sec{=MOD(ss,60) \# 0}}
{QUOTE"{=IF(hr=0,12,hr)}:{mn}:{sec}" \@ "h:mm:ss "}{IF{=hr}< 12 a.m. p.m.}}
Quote:
|
not wanting to sound confrontational, but rather as an FYI
|
That's OK - no offence taken. What you'll find is that, with a directory merge, all your page headers will be the same because they all share the same post-merge content. You can still see that in the other document you posted. BTW, that one still has live DATE fields in the header. To convert those to static text during the mailmerge, open the mailmerge main document, select those fields, press Ctrl-F9 to enclose them in another field, then type 'QUOTE' inside the left field brace.