hi,
Need some VBA code to do the following please.
This is the layout of my master form. Top row are the headings. I have created a macro which populates this information from another spreadsheet which changes weekly.
Next I need a macro to send information from Column A to column E to the email address in Column J.
Some will have multiple entries and I need these to populate only 1 email (one email for each Customer - email address with potentially multiple entries).
It should pick up the Customer name in column F1 (To .....), add a line of text asking for updates on these entries (final text to be confirmed) and finishing off with Kind Regards and the "User's" signature if present in Lotus Notes.
I am asking for a lot here so any help greatly appreciated.
A1 B1 C1 D1 E1 F1 J1 [TABLE="width: 769"]
Policy Number
Reg
Date
W
Description of Error
Customer Email addres
Name
[/TABLE]