MailMerge in Access XP problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: dt (diannterrill_at_yahoo.com)
Date: 10/27/04 

Date: 27 Oct 2004 01:08:13 -0700

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

Relevant Pages

  • Re: Alternate rows with bold font
    ... Viewed report in design view ... This is why I need to alternate between bold and normal font. ... property of a line control. ... Code the Detail Section Format event: ...
    (microsoft.public.access.reports)
  • Re: OnFormat action not executed when exporting to PDF
    ... Strange behaviour though... ... "Rob Parker" wrote: ... does show bold text. ... we can make a simple report: ...
    (microsoft.public.access.reports)
  • Re: Can we set two different text parametars in one textbox?
    ... Not sure I would call it an "easy solution" though. ... that on your report, Access is likely to think you are referring to the Name ... Roman, bold, italic, 15 points and "female" in Times New Roman, bold, 12 ...
    (microsoft.public.access.reports)
  • Re: Fasr Report 3.14 Slow report preparation with UserDataset
    ... when performing a benchmark on prepare report on a single record for ... PrepareReport is 4860 ms. ... If i try to check control name to avoid this, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: OnFormat action not executed when exporting to PDF
    ... However, if I change that to Me.Text1.FontWeight=700 (using the value given in the help file for enumeration of the Bold constant), then the PDF file does show bold text. ... we can make a simple report: ... on one of the controls onformat event, add code to make the text bold: ... A pdf file is created and opened in your pdf viewer. ...
    (microsoft.public.access.reports)