Access 2000 and Outlook 2003

[Guest]

Hello, everyone.

I recently updated my Office from 2000 to 2003 but left Access 2000
installed, as I have an app done using VBA and I know that there might have
been an issue running it on Access 2003.

Here is the dilemma: I have a call to send an e-mail to customers, in the
application.

It captures the customer's information and the body of the e-mail is
hardcoded. When I click on the button to send the e-mail, a new e-mail
opens, it captures the e-mail address of the customers, the subject of the
e-mail, but the body is empty. I did step into the coding to verify what
was going on and it does go through and it show as being performed, but the
e-mail is still blank.

Any ideas?

Thanks,


Antonio

 

[Dean]

If you are automating Outlook 2003 from Access 2000, first check your
references to make sure you have the correct version of Outlook, next take
a look at the font being used for the body of the message, is it white on a
white background by chance?

 

[Guest]

Hi, Dean, thank you for replying. In the References I have Outlook 11 and I
don't specify a font or color.

Here it is:

DoCmd.SendObject acSendNoObject, , , txtEmail.Value,
txtAltEmailAddress.Value, "gemdist", "Subscription Confirmation" _
, "Dear " & txtContactFName.Value & "," & vbCrLf & vbCrLf & "Thank
you for renewing your subscription to " & cboYRSubTitle1.Value & "." & vbCrLf
& vbCrLf & _
CompanyName.Value & "'s one-year access has been set up." & vbCrLf &
vbCrLf & "To access go to: " & cboYRSubTitle1.Column(5) & _
vbCrLf & vbCrLf & "Select " & cboYRSubTitle1.Value & " from the
Product " _
& "drop-down list." & vbCrLf & vbCrLf & "Enter your username and
password" & vbCrLf & vbCrLf & "Click on 'Submit'" & vbCrLf & vbCrLf & _
"Subscription Expiration Dates:" & vbCrLf & vbCrLf & _
cboYRSubTitle1.Value & " " & txtYRSubExpDate1.Value