E-mail text

[Guest]

Hi

I am trying to use send object to send an e-mail, the problem i have is
that i want in the message the Quote Number that is on the form where the
message is pressed. I tried putting the message as :

"New Quote approved to commence QN: " & [Forms]![Frm_Bid Details]![Quote
Number]


This didn't work, that is what came up in the e-mail i wanted the actual
number not the test sayin where it was. Can this be done?

Cheers

Danny

 

[Rick B]

Can you paste the EXACT code in here that you used?


--
Rick B

Hi

I am trying to use send object to send an e-mail, the problem i have is
that i want in the message the Quote Number that is on the form where the
message is pressed. I tried putting the message as :

"New Quote approved to commence QN: " & [Forms]![Frm_Bid Details]![Quote
Number]


This didn't work, that is what came up in the e-mail i wanted the actual
number not the test sayin where it was. Can this be done?

Cheers

Danny

 

[Guest]

I used a macro not VBA, I have written it in VBA now and its working.

DoCmd.SendObject acReport, "Rpt_Rfq Ack Email", "SnapshotFormat(*.snp)",
"(e-mail address removed)", "", "", "New Bid", "New Quote approved to
commence. Please see attachment. This is an automated notification, please
do not respond. QN: " & Forms![Frm_Bid Details]![Quote Number] & "",
False, ""


That works

Thanks anyway

Can you paste the EXACT code in here that you used?


--
Rick B

Hi

I am trying to use send object to send an e-mail, the problem i have is
that i want in the message the Quote Number that is on the form where the
message is pressed. I tried putting the message as :

"New Quote approved to commence QN: " & [Forms]![Frm_Bid Details]![Quote
Number]


This didn't work, that is what came up in the e-mail i wanted the actual
number not the test sayin where it was. Can this be done?

Cheers

Danny