It is copying and replacing values from 2nd, 3rd and 4th column and puts in the cell under specific line of characters the values. The problem is that it is copying with the same data for all rows further. How to force jumping to next row?
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you very much for this reply. It was really helpful!
I have also such questions, maybe you know the answer, as want to improve the quality of work for my wife, who has to send similar mails to multiple individuals:
1. How can I change below to have flexible?
HTML Code:
to
HTML Code:
2. How can I rerun the mentioned above macro? Let's say my wife forgot to correct the name of individual and need to have the mail template populated once again. Can we somehow have it rerun?
3. How can I add macro, which will copy paste the populated template of text from (J2:till is populated), add mails in section TO in mail message from the same row (F2:till is populated) and add have predefined subject of mail for Outlook application?
Bookmarks