EMAILS

WORKING PAPERS: EXCEL & VBA

Every time a stage of completion is achieved an email requires to be sent to pass it to the next stage.

Initial Monthly Process (10mins)

  1. Navigate to outlook
  2. Draft email
  3. Update as necessary cells
  4. Send
  5. Repeat for each stage

New Monthly Process (2min)

  1. Tick box
  2. Send
  3. Repeat for each stage

CODE

Get user defined email in a neat format for readability

="Hey "&C26&",__That is "&Name&" for "&TEXT(ReportingMonth,"mmmm")&" ready to review.__Thanks,__"&C27

Reformat for input

=SUBSTITUTE(PartnerEmailBody,"__","%0A%0A")

If you're interested in seeing the code below, please reach out @sidtrengove

Put into mailto formula

="mailto:"&C25&"?"&"__removed__&"&cc="&C26&"&body="&C28

Create clickable link

=HYPERLINK(Macr__removed__6,"Email")