W
wallyb
I have a fairly complicated invoice system:
Worksheets are the individual invoices and have many vlookup functions
I email each WS invoice to an email address on the WS. I use Mail Send
in VB to email the worksheets to the different email addresses.
Some of my customers are getting the Invoice WS with only the #VALUE
in the space where the numbers belong.
Most customers are getting it OK - in my tests everything I receive is
OK.
Can the invoices be saved or copied in some way (maybe Paste Value)
before emailing so that the formula results will be OK?
Thanks
Worksheets are the individual invoices and have many vlookup functions
I email each WS invoice to an email address on the WS. I use Mail Send
in VB to email the worksheets to the different email addresses.
Some of my customers are getting the Invoice WS with only the #VALUE
in the space where the numbers belong.
Most customers are getting it OK - in my tests everything I receive is
OK.
Can the invoices be saved or copied in some way (maybe Paste Value)
before emailing so that the formula results will be OK?
Thanks