D
dt
A few months ago, this group was extremely helful in getting my
problem solved in Access 2000. It worked swell... until we updated to
Access XP - now the code does not work... so, it's back to the drawing
board.
Here's the problem as stated in May 03:
I'm still having difficulty with mailmerge to word. Here's the
problem: I have a table which has the following fields: Subject,
Remarks, POC, WeekOF
What I need is a report for a specified week which looks like:
Subject: Remarks POC (where Subject is bold, all Caps, Remarks are not
- lines wrap when they need to).
Example:
CAMP DAY UPDATE: The contractor is approximately 75% complete with
the road repair project. The unit has identified 9.6 miles of road
that it would like re-constructed if funding becomes available. Maj
Isl/LGWC/480-2222
CAMP DAY UPDATE - Subject would be bold.
I tried to do this in an Access Report, but couldn't get the Bold to
work and still get the report format I needed. And... the report
needs to be in Word (eventually) anyway, so I found that using a
mailmerge document got me the formatting I needed!
Here's my merge document:
«Subject»: «Remarks» «POCName» (Subject is in bold - short, sweet
and to the point)
This is a Directory (used to be catalog) merge type. I'm finding this
all to be much more difficult in XP than it was in 2000.
My first problem is I can't seem to find documentation on any of these
calls, so I'm kind of doing the 'trial and error' method (which is not
working). If I could find documentation, I sure could do this on my
own.
Next, before Albert Kallal tells me to look at his simple solution,
your web site says that it is for a SINGLE record - I need the
solution to include many records - I'm using a query as the data
source - so, it appears that the single record solution will not work.
So - Here's what I want to do - programmatically have the merge
execute to a new document and save the new document.
HELP!
Diann
problem solved in Access 2000. It worked swell... until we updated to
Access XP - now the code does not work... so, it's back to the drawing
board.
Here's the problem as stated in May 03:
I'm still having difficulty with mailmerge to word. Here's the
problem: I have a table which has the following fields: Subject,
Remarks, POC, WeekOF
What I need is a report for a specified week which looks like:
Subject: Remarks POC (where Subject is bold, all Caps, Remarks are not
- lines wrap when they need to).
Example:
CAMP DAY UPDATE: The contractor is approximately 75% complete with
the road repair project. The unit has identified 9.6 miles of road
that it would like re-constructed if funding becomes available. Maj
Isl/LGWC/480-2222
CAMP DAY UPDATE - Subject would be bold.
I tried to do this in an Access Report, but couldn't get the Bold to
work and still get the report format I needed. And... the report
needs to be in Word (eventually) anyway, so I found that using a
mailmerge document got me the formatting I needed!
Here's my merge document:
«Subject»: «Remarks» «POCName» (Subject is in bold - short, sweet
and to the point)
This is a Directory (used to be catalog) merge type. I'm finding this
all to be much more difficult in XP than it was in 2000.
My first problem is I can't seem to find documentation on any of these
calls, so I'm kind of doing the 'trial and error' method (which is not
working). If I could find documentation, I sure could do this on my
own.
Next, before Albert Kallal tells me to look at his simple solution,
your web site says that it is for a SINGLE record - I need the
solution to include many records - I'm using a query as the data
source - so, it appears that the single record solution will not work.
So - Here's what I want to do - programmatically have the merge
execute to a new document and save the new document.
HELP!
Diann