B
BillyRogers
I have an access program that uses this line to send an email.
DoCmd.SendObject acQuery, Report1, "MicrosoftExcel(*.xls)", Address, Copy,
Blind, Subj1 & "-" & txtMonthEnd.Value, Message, True, ""
It works fine on a computer where I'm running office 2000 and windows 2000.
I have a second computer with Office 2003 and Windows 2000.
When I use this program on my Office 2003 machine it sends the email, but in
the sent folder the "To" fields looks like this ";";"
that is quote, semi-colon, quote, semi-colon, quote.
I've checked and the email does get routed to the recipient. This program
is used to mail hundreds of reports to our customers and we save them all in
a folder and frequently need to search for them by the to field since many of
them have the save subject line.
Can this be fixed or is it just an Outlook 2003 bug? This is preventing
our whole deptartment from upgrading to Office 2003.
Any advice would be appriciated.
Thanks,
--
Billy Rogers
Dallas,TX
Currently Using Office 2000 and Office 2003
DoCmd.SendObject acQuery, Report1, "MicrosoftExcel(*.xls)", Address, Copy,
Blind, Subj1 & "-" & txtMonthEnd.Value, Message, True, ""
It works fine on a computer where I'm running office 2000 and windows 2000.
I have a second computer with Office 2003 and Windows 2000.
When I use this program on my Office 2003 machine it sends the email, but in
the sent folder the "To" fields looks like this ";";"
that is quote, semi-colon, quote, semi-colon, quote.
I've checked and the email does get routed to the recipient. This program
is used to mail hundreds of reports to our customers and we save them all in
a folder and frequently need to search for them by the to field since many of
them have the save subject line.
Can this be fixed or is it just an Outlook 2003 bug? This is preventing
our whole deptartment from upgrading to Office 2003.
Any advice would be appriciated.
Thanks,
--
Billy Rogers
Dallas,TX
Currently Using Office 2000 and Office 2003