E-mail tool - issues with body of e-mail text

Question

Hello -

I am using the e-mail tool for an annual project to distribute customized files to a large number of individuals at my company. I used attached macro in Spring 2020 to send out the e-mails and it allowed me to include the "&" within the Body of email text and also included the paragraph spacing in the final e-mail that was sent. However, when I am attempting to use the same macro currently, it is producing an error. Removing all of the "&"s from the text allowed the e-mails to send, but the paragraph spacing was omitted resulting in the e-mail body being a difficult to read lump of text.

I would appreciate any insights into why these things are coming up as issues now, but were not previously. Also, any suggestions for how to resolve so I can send out any remaining e-mails for the year with improved formatting. Thank you!

Email tool.PNG

Luke_C · Accepted Answer

@laura2

I can't speak to why this error would be happening, however if you use a Report Text tool to generate the body of your email you shouldn't have any issues. I just tested and was able to send an email with an '&' with no issues. The report text tool also will let you insert names via the 'available fields' option in it's configuration window.

CharlieS · Accepted Answer

The use of Reporting tools will be necessary to format the content for the email tool.

In this case, I recommend using a Report Text tool instead of the Formula tool. You can still reference fields like the Formula tool to create dynamic content for each email. Here's what that might look like in the Report Text tool:

An example is also attached. Check it out and let us know if you have any questions.