bsharath
asked on
Excel macro to create emails from the data in a sheet.
Hi,
Excel macro to create emails from the data in a sheet.
In the sheet called DCS want to filter one colum and create emails of just the unique names in a colums of specific colums data into new excel sheets and create a email.
More explanation in the attachment
regards
sharath
Write-to-new-workbooks.xls
Excel macro to create emails from the data in a sheet.
In the sheet called DCS want to filter one colum and create emails of just the unique names in a colums of specific colums data into new excel sheets and create a email.
More explanation in the attachment
regards
sharath
Write-to-new-workbooks.xls
So ... if there are 2 rows of the Column K with the same name, which do you want to retain.... the 1st one or the second one... or some other rule?? Rest is straightforward.
ASKER
If i have 2 same names in colum "K" . then i want both with the headers into the new worbook
ASKER
Its mainly to email each person on how many machines he has
So say Sha is in 2 places then email him 1 time with the attachment with both the rows data
So say Sha is in 2 places then email him 1 time with the attachment with both the rows data
Link your excel file to MS Access.
Create a report.
Print to pdf and Email it.
Create a report.
Print to pdf and Email it.
ASKER
Any views with a macro please...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you