L
Linda Brown
(Sorry, I replied to previous post but meant to post.)
But what if the link is on a subform? (I can get this to
work on one machine but not another, even though I have
copied the latest to another machine and even though all
references are the same for both machines.)For instance,
I have the following code placed inside the "subform"
instead of adding it somewhere on the Main form.
As I said, it works on my machine but not another's.
When we try it on another machine, the machine locks up.
We can save and exit Outlook but when we return to
Outlook, the message is not in the Drafts section but
rather in the "Inbox" without the "From" showing at this
point. The reason we want to open it for edit is because
we need to change a date and attach a document. (When we
do a mass mailing, we have something different set up in
a module that automates the entire process.)
At first I had set this to Private and then changed it to
Public, thinking perhaps this would make a difference but
it has not made a difference. Here is the code.
Public Sub ConEmail1_DblClick(Cancel As Integer)
DoCmd.SendObject acSendNoObject, , acFormatRTF,
[ConEmail1], , , "NRV/Mack " & _
"Routing Instructions", "Please replace any
previous routing instructions with " & _
"the attached updated copy. Confirmations are
required on this update dated " & _
"October 2, 2003. The attached document contains
your current routing instructions " & _
"for product shipped from the locations noted on
Page One to Mack " & _
"Trucks in Dublin, VA, and its third-party
suppliers. Make corrections to the shipping " & _
"location if necessary, then sign and date the first
page, and fax it back " & _
"to Volvo Logistics North America at 540-674-8730.
If you are " & _
"not the appropriate person to receive these
instructions, " & _
"please forward them to the responsible party.", True
End Sub
Thanks for any assistance.
--Linda Brown
But what if the link is on a subform? (I can get this to
work on one machine but not another, even though I have
copied the latest to another machine and even though all
references are the same for both machines.)For instance,
I have the following code placed inside the "subform"
instead of adding it somewhere on the Main form.
As I said, it works on my machine but not another's.
When we try it on another machine, the machine locks up.
We can save and exit Outlook but when we return to
Outlook, the message is not in the Drafts section but
rather in the "Inbox" without the "From" showing at this
point. The reason we want to open it for edit is because
we need to change a date and attach a document. (When we
do a mass mailing, we have something different set up in
a module that automates the entire process.)
At first I had set this to Private and then changed it to
Public, thinking perhaps this would make a difference but
it has not made a difference. Here is the code.
Public Sub ConEmail1_DblClick(Cancel As Integer)
DoCmd.SendObject acSendNoObject, , acFormatRTF,
[ConEmail1], , , "NRV/Mack " & _
"Routing Instructions", "Please replace any
previous routing instructions with " & _
"the attached updated copy. Confirmations are
required on this update dated " & _
"October 2, 2003. The attached document contains
your current routing instructions " & _
"for product shipped from the locations noted on
Page One to Mack " & _
"Trucks in Dublin, VA, and its third-party
suppliers. Make corrections to the shipping " & _
"location if necessary, then sign and date the first
page, and fax it back " & _
"to Volvo Logistics North America at 540-674-8730.
If you are " & _
"not the appropriate person to receive these
instructions, " & _
"please forward them to the responsible party.", True
End Sub
Thanks for any assistance.
--Linda Brown