Posts by Amadeu • 3 points
4 posts
-
0
votes1
answer7301
viewsQ: How to break the line in a string in VBA?
I’m having a hard time putting a line break inside an automated email text by macro. I create the e-mail with the following Cód: "Necessitamos dos extratos do mês de " & Format((Month(Now) - 1),…
-
0
votes2
answers127
viewsA: Difficulty in identifying min value and sending selected Cells by email. VBA
I was able to make the e-mail with image in the body, saving the selected cells in a temporary folder. I added the update to Pivotable because the selection is in a table already formatted, with the…
-
0
votes2
answers127
viewsQ: Difficulty in identifying min value and sending selected Cells by email. VBA
I’m trying to do a macro where I can identify if there’s a due date in the column L which expires within a month, and if any, launch a msgbox and send an e-mail via Outlook pasting the entire table…
-
0
votes2
answers184
viewsQ: Difficulty to loop in VBA
I made a code Visual Basics to identify the maturity of insurance policies and raise a pop-up and fire an email alerting you if you are close to maturity. The database is displaying the Policy…