vielou

[vielou]

Personalized Emailer Field Inserter, using a CSV file, from which I removed a lot of columns, here’s what I got:
CMimeObjectExtractor.DoSanityChecks
C:Documents and SettingsSQuesnMy DocumentsAdvansysFormativAppletsPersonalized Emailer_Flexalock.vbf
Cannot find file
‘C:Documents and SettingsSQuesnLocal SettingsTempadvfmtmpMime.822’ at line 9394, column 7

[vielou]

I have looked very closely and I really can’t see where I could have incorrect data structure in my CSV file. My CSV file does have one row per line, each column separated by the “,” character (double quotes because of single quotes ‘ found in some fields). I do choose the comma as the separator character in the Personalized Emailer solution, but no luck.

My CSV file won’t open properly in MS Excel because of the 1000 fields accross, too large. So I review my file using TextPad. There is no hard return character in column values. Wouldn’t it be possible for you to test this, if I could send you the Word and CSV test files (only 45 rows)?

The registrars office here at the college would need a solution A.S.A.P., I really would need some help.
Thank you

[vielou]

I’ve installed and tried your 30 day trial Personalized Emailer. When trying the Personalized Emailer Field Inserter, using a CSV file, here’s what I got: Sorry, the CSV file’s structure could not be deternined. Please ensure you have specified the correct field seperator character. I did tick ‘First line contains field names’ and my separator chararcter is a ‘,’. Are there limits to the data source to be used? My file has only 45 rows of data, with 1000 fields accross. I’d like very much to have this solution work for us, but it doesn’t look too good…
Thanks for your help

[vielou]

Currently, we are using the following solution, using Word 2003:
– opening up template document
– setting main document type to ‘E-mail messages’
– opening data source, .csv file
– when having a look at ‘Mail Merge Recipients’, all EmailIDs in the file look great
– then ‘Merge to E-mail’, To: EmailID, Mail format: Plain text (and not HTML), all looks fine for all records HOWEVER, some emails are sent to the wrong recipient email (2%).
(HTML Mail format won’t send a thing.)
(Attachment Mail format seems to go through ok but not necessarily want we want.)

You strongly recommend NOT using Microsoft Word … we have lots of IFs when inserting MERGEFIELDs in the template. Can you recommend another tool with which we could do the same? And is Word not compatible even if it is a plain text message we are working with?

Thank you

[vielou]

Thank you for your quick response.
– I am NOT using the Personalized Emailer solution.
– YES, my template message is created in MS Office Word 2003 (11.6502.6408) SP1. You recommend to use which HTML editor?
– We are running Novell GroupWise 7.0 (7.0.1 14/12/2006, 553).
– Yes I can re-produce this behaviour with a smaller 45 row .csv file.

[Author]

Replies