edit a report letter

[neous]

i'm trying to work with this database.
i want to know how to change a few things
we have a command button that generates a letter
i need to edit that letter as it contains names and numbers no longer in the office

is there a way i could find that letter

i tried to have sent to a .rtf file which i could modify, but that's tolerable for a dozen of recipient not 2 to 3 hundreds


thanks

 

[RuralGuy]

Can you post the code that is behind the Command Button?

 

[neous]

thanks for the reply sorry for the delay in response

here is the code behind the command button

Private Sub RENEW_AWARD_BUTTON_Click() 'this is the button that finalizes a Renewable award
On Error GoTo Err_Command662_Click

Dim stDocName As String

stDocName = "RENEW_AWARDLTR" ' string with the name of the renewable award letter
'DoCmd.OpenReport stDocName, acNormal ' This prints the award letter whose filter is Current student
DoCmd.OutputTo acReport, stDocName

Comments.Value = Comments.Value & vbNewLine & ">>> Renewable Award letter for $" & [RENEWABLE_AMOUNT] & " printed on " & Format(Date, "short date")
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'The previous couple lines update the comments screen
'With more time another couple lines should have been added to update the Action History Field
Exit_Command662_Click:
Exit Sub

Err_Command662_Click:
MsgBox Err.Description
Resume Exit_Command662_Click

End Sub

 

[RuralGuy]

Have you opened the RENEW_AWARDLTR Report in design mode?

 

[neous]

thanks very much

that is indeed the remedy

 

[RuralGuy]

Glad to assist and thanks for posting back with your success.