Type mismatch: Cannot coerce parameter value. Outlook cannot translate your string

Hi All
I am hoping someone can help.

I have 2 macros that work when run separately:

Build_Pivot_Row_Sheet ← Click the 'SLA Checks' button on the All Data sheet
Send_Email

[Build_Pivot_Row_Sheet] loops through all the 'SLA' sheets and shows the pivot table row details, then copies & pastes it into a sheet called 'Pivot Rows'
[Send_Email] takes the info from the 'Pivot Rows' and sheet creates a summary in a temp file and attaches it to an email

When I run them separately they work.
But when I call [Send_Email] at the end of the [Build_Pivot_Row_Sheet] I get an error at the line where it would populate the email address field?

Type Mismatch.png

Any advice would be greatly appreciated
Thanks
Vicky

Does it help if you put DoEvents before the .To = ... line?

In layman's terms, it was "computer says no". I can't really say why, but the code worked fine when run separately, and also when stepped through, so it appeared to be a timing issue, and DoEvents allows the computer to catch up with itself, if you like.