There have been a number of postings regarding outputting data from Access to Excel, but my problems is slightly different.
I want to output email addresses to MailChimp, but my members database contains a number of cases where two partners use the same email address. MialChimp does not allow duplication of an email address. Data is imported into MailChimp via a csv Excel file where I have removed duplicate records. Up till now this has been fine with just one email going to two partners.
Now I want to email all members via MailChimp and therefore need to create two Excel csv files followed by two MailChimp mailings. The code I need will read through all records from a query and output most of the records to Excel file 1, with the duplicates going to Excel File 2. Therefore bulk transfer is not possible. I also want to clear all rows in each Excel file before each run other than the first row which contains column headings.
Any ideas on the best approach?
I want to output email addresses to MailChimp, but my members database contains a number of cases where two partners use the same email address. MialChimp does not allow duplication of an email address. Data is imported into MailChimp via a csv Excel file where I have removed duplicate records. Up till now this has been fine with just one email going to two partners.
Now I want to email all members via MailChimp and therefore need to create two Excel csv files followed by two MailChimp mailings. The code I need will read through all records from a query and output most of the records to Excel file 1, with the duplicates going to Excel File 2. Therefore bulk transfer is not possible. I also want to clear all rows in each Excel file before each run other than the first row which contains column headings.
Any ideas on the best approach?