Hello All,
I have a macro that writes the Contact Name and Contact e-Mail of a customer in a cell on their Excel Sheet, through the use of VLOOKUP (which works 100% as intended). Then, the Contact Name and Contact e-Mail gets sent to a variable for use by another macro that e-Mails a HTML version of the Sheet, places the Contact e-Mail in the To field, and the Contact Name into the body (it then deletes the sheet).
The second macro works 100% as intended with no errors on the developer machine. However, it isn't working for the users and it does not return an error. However, if I "step through the code" line by line, it works fine on developer or user machine. Is it possible that the code is executing to quickly to allow the VBA-entered formula to work?
If so, is there a way to program a delay to allow the program to take it easy? If so, what is a solid "wait period" for inbetween sub routines?
I appreciate all of your help.
Bookmarks