Jump to content
Macro Express Forums

Email Recipient As A Variable


Recommended Posts

I am trying to create a Macro that will copy some cells including Recipient name and company name from an Excel file. The Recipient name will be in the form of an email address. I need the Macro to send an email to that Recipient email address. I have tried setting that email address to %T1%, then in the "send email" properties, in the to field, I have put %T1%. I exit that, reopen and the %T1% disappears. Is there a way to have the email sent to that variable recipient?

Link to comment
Share on other sites

It's possible that when you are copying the information from Excel, that you are getting extra data that is not visible to you. If this is the case, the e-mail address most likely contains hidden characters. To remove these characters, try using the Trim option in the Variable Modify String command.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...